Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok, Here is an example of what I am trying to do. All three columns of
information go with each client, using 3 seperate rows. I also put a border around each set so that it looks better and helps me to see more clearly each set of rows as seperate information regarding each client. Now, when I go to sort it in alphabetical order, it moves the client names up into my blank rows under each client name and will not see the blank cells as being part of the other group. Also, my borders stay with the cells instead of moving with the client information that I put it around in the first place. This is really a problem for me because my client list changes and grows everyday. Every time I add a client and sort it, my information is screwed up again and I have to go back and redo my borders and fix the blank cells, etc. A B C ________________________ John Doe 1111 RRRR 4444 UUUU 7777 YYYY ________________________ Jane Doe 5555 UUUU 8888 IIII 0000 OOOO ________________________ Sarah Doe 7777 PPPP 5555 BBBB 9999 CCCC ________________________ I hope this explains it well enough for someone to help me. I'm frustrated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel | |||
Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions |