| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort a group
I am having problems sorting columns. I want to arrange my columns by
birthday here is an example of my speadsheet. Employee Name Birthday Employee Name Birthday Joe 01-18 Doe 02-20 It will not sort the whole worksheet correctly |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort a group
Is that the actual layout of your data? Across rows?
Would be much easier if the names were in one column and the dates were in an adjacent column, say A and B Then just select A and B and sort on B You can sort across a row.......DataSortOptionsSort left to right Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 09:58:05 -0700, mcblts wrote: I am having problems sorting columns. I want to arrange my columns by birthday here is an example of my speadsheet. Employee Name Birthday Employee Name Birthday Joe 01-18 Doe 02-20 It will not sort the whole worksheet correctly |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort a group
Hi,
Your layout of data is incorrect. You could infact have this way: Employee Name Birthday Joe 01-18 Doe 02-20 Challa Prabhu "mcblts" wrote: I am having problems sorting columns. I want to arrange my columns by birthday here is an example of my speadsheet. Employee Name Birthday Employee Name Birthday Joe 01-18 Doe 02-20 It will not sort the whole worksheet correctly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group & sort rows that have a specific value in column C | Excel Worksheet Functions | |||
| Group and sort on two columns | Excel Discussion (Misc queries) | |||
| Excel subtotal group sort | Excel Worksheet Functions | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| Sort by group | New Users to Excel | |||
Linear Mode
