Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouped sorting
Hello
I have data grouped in 3 columns across my sheet. I would like to sort these groups by the first cell in each group. Due to line wrap the example is column wise but my sheet the data is row wise Trans# Amount RepID 123 500 JD Trans# Amount RepID 425 300 SP Trans# Amount RepID 256 250 AR Sorted.... Trans# Amount RepID 123 500 JD Trans# Amount RepID 256 250 AR Trans# Amount RepID 425 300 SP Thanks for all replies Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouped sorting
Scot wrote:
I have data grouped in 3 columns across my sheet. I would like to sort these groups by the first cell in each group. Due to line wrap the example is column wise but my sheet the data is row wise Trans# Amount RepID 123 500 JD Trans# Amount RepID 425 300 SP Trans# Amount RepID 256 250 AR I'll suggest using Autofilter, which works with rows, not columns. Select your table. Data; Filter; Autofilter. Hit the Trans# arrow and select 'Custom'. Show rows where Trans# <does not equal <Trans#. This will show only the data rows. Data; Sort; Trans# (has header row). Data; Filter; Autofilter to remove the filter. Then you'll have to copy and paste special (transpose). (This is on the sheet, not in code; should be able to do with code) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting grouped cells | Excel Worksheet Functions | |||
sorting grouped rows | Excel Discussion (Misc queries) | |||
Grouped Items won't Stay Grouped When Moving Object | Excel Discussion (Misc queries) | |||
find value in A, grouped to B | Excel Worksheet Functions | |||
Grouped Workbooks | Excel Discussion (Misc queries) |