sorting custom
have nbrs in column b 1 - 10 repeated many times over
Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups from 1 - 10 can this be done in excel ? Any Help greatly appreciated. Thank You |
sorting custom
in Column C put in this formula in the first row
=countif($B$1:B1,B1) then drag fill down the column. Now sort the data on This column first, then column B as the second key. -- Regards, Tom Ogilvy "Curt" wrote in message ... have nbrs in column b 1 - 10 repeated many times over Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups from 1 - 10 can this be done in excel ? Any Help greatly appreciated. Thank You |
sorting custom
maybe i didn't follow still get all1s together 2s together not a 1 2 3 4 5
repeat sort not to good at this Thanks "Tom Ogilvy" wrote: in Column C put in this formula in the first row =countif($B$1:B1,B1) then drag fill down the column. Now sort the data on This column first, then column B as the second key. -- Regards, Tom Ogilvy "Curt" wrote in message ... have nbrs in column b 1 - 10 repeated many times over Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups from 1 - 10 can this be done in excel ? Any Help greatly appreciated. Thank You |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com