Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sorting
I am soritng a spreadsheet (A-Z by last name). So, for example, data for
person 1 is on row A1-G1 (takes 1 row) but then column H will have data for that person in rows 1-3 so when I sort at this point the data in H2-3 will get pushed down to the end of the sheet. What I am doing now is typing the persons last & first name 3+ times so that it sorts all the persons information along with it. Is there a different way of doing this? I know...Hard to explain...I hope someone out there knows what i'm talking about! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sorting
Hi,
What you need to do is fill in the missing repeat names. This could be in one or more columns, but let me assume it is in A1:G100. Highlight this range and 1. Press F5, Special, Blanks, OK 2. Type =, Up, Ctrl+Enter. (Type the equal sign then press the Up arrow key once and finally press Ctrl+Enter. 3. Select the range A1:G100 again and press Ctrl+C (copy) 4. Choose Edit, Paste Special, Values. 5. Now you can sort, keeping everything together. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Athletica" wrote: I am soritng a spreadsheet (A-Z by last name). So, for example, data for person 1 is on row A1-G1 (takes 1 row) but then column H will have data for that person in rows 1-3 so when I sort at this point the data in H2-3 will get pushed down to the end of the sheet. What I am doing now is typing the persons last & first name 3+ times so that it sorts all the persons information along with it. Is there a different way of doing this? I know...Hard to explain...I hope someone out there knows what i'm talking about! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) |