Howdy, Stranger!
Categories
Options
Excel feckwittery
I have an excel file. Across the top I have name, contact info, and then 4 events in separate columns. For each name added I have put a 1 in the columns they can attend. I am now trying to sort them into blocks of columns so that I can mail each block of people. Excel doesn't seem to want to sort by column, ascending.
What am I doing wrong? Should I be doing it another way?
Thank you!
The materials in this website are in no way intended to replace the professional medical care, advice, diagnosis or treatment of a doctor, qualified personal trainer, therapist, dietitian or nutritionist Runners's World, Part of the Hearst UK well-being network © Copyright 2017
Comments
office 2003
data and then sort as from top row of functions, I didn't know there were alternatives
I'm a bit thick, me
No, that sounds about right.
You might need to tell excel that you have a header row, or you might need to highlight all the data, so that it sorts the entire block, not just one column. You might want to check that the 1 are numbers, or text (shouldn't make any difference one way or the other, but it will if they are a mixture)
What version are you in? It should work in all of them, but the latest package has changed somewhat.
Done it.
Thank you.
I hate excel with a passion.
In a previous life I used to produce a lot of statistical reports from Excel documents. They still bring me out in a cold sweat
(wails)
An Excel question and I arrived too late!
I'm the spreadhseet queen at work, but we only really use a tiny bit of what Excel's capable of. I only know what I've picked up as I went along, so was chuffed with myself last week. I managed to combine 3 separate sheets into one workbook, then put some formulas in that meant I didn't have to keep skipping between them all and manually enter them.
No-one understood my joy at that.
My next mission (that I invented for myself through sheer bordeom) is to chart waste against turnover/month for each unit and present it all in coloured charts. I'm very excited about this. My colleagues think I'm mad.
I can kinda understand this. i've grown to really like excel over the last few years. I even started keeping a running log in an excel spread sheet, and if I hadn't got injured would probably produce some coloured charts at the end of the year!
....................
Running Blog
Okay...to be fair I didnt write the original myself but I did find on t'web, its for names that are surname, first name.
Last name (if its first in the cell):
=LEFT(A2,IF(ISERROR(FIND(",",A2,1)),LEN(A2),FIND(",",A2,1)-1))
First name (if its second in the cell):
=TRIM(IF(ISERROR(FIND(",",A2,1)),A2,MID(A2,FIND(",",A2,1)+1,
IF(ISERROR(FIND(" ",A2,FIND(",",A2,1)+2)),LEN(A2),
FIND(" ",A2,FIND(",",A2,1)+2))-FIND(",",A2,1))))
So you can reverse them if the cell is first name, surname
Also works with other text as well for example if you have a ; : or [ seperating the text instead of a ,
There are other ways of splitting cells for example based on LEN and then a number of characters, but thats dependant on each cell being the same length!
*makes notes in her geek pad*
Thanks Curly
And if it's first name, space, surname...
First name:
=LEFT(A2,FIND(" ",A2)-1)
SURNAME
=RIGHT(A2,LEN(A2)-FIND(" ",A2))
Simples.
*pokes head back in*
Good to see geekdom is alive and well - as you were
joins SVT wailing - arriving far too late to answer
ooh text to columns, and I simply love a good concatenateAt work I am seldom introduced by my name - first comes, this is the 'spreadsheet queen'
Yesterday I sat with a colleague to help them, in the end I was told to 'sit on my hands' as I kept wanting to grab the mouse.
copies Womble and adds to favourites, slipping off anorak for now
Does anyone want to know how to get rid of N/A results from a VLOOKUP list?
<adds to favourites>