Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Sort Data
I have a file as below
Which has Store Numbers in Coloum A - all the store that are in coloum A are unique - no duplicate store numbers - but every store will appear in one of the coloum in R1, R2 or R3 only once - so if store 9562 is under R2 it will not reappear in any other R's - so basically we are trying to figure out which store is coming under which "R's" Store R1 R2 R3 9562 2301 5640 8352 8352 8362 5641 6003 7805 5604 9562 6004 8362 5821 5645 6005 5675 5607 5646 6441 6378 5609 4587 7805 5821 5675 5652 6009 6441 7804 5664 6010 7010 6259 5682 6378 7508 5614 7508 6013 7804 5615 7010 6015 4587 6259 6985 1458 2301 The Result should be as below Store R1 R2 R3 9562 2301 ---- 8352 8352 8362 ---- ---- 7805 ---- 9562 ---- 8362 5821 ---- ---- 5675 ---- ---- 6441 6378 ---- 4587 7805 5821 5675 ---- ---- 6441 7804 ---- ---- 7010 6259 ---- 6378 7508 ---- 7508 ---- 7804 ---- 7010 ---- 4587 6259 6985 1458 2301 Any help is appreciated Thank You Deepak |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to Sort Data
On Mon, 29 Dec 2008 14:40:04 -0800, Deepak
wrote: I have a file as below Which has Store Numbers in Coloum A - all the store that are in coloum A are unique - no duplicate store numbers - but every store will appear in one of the coloum in R1, R2 or R3 only once - so if store 9562 is under R2 it will not reappear in any other R's - so basically we are trying to figure out which store is coming under which "R's" Store R1 R2 R3 9562 2301 5640 8352 8352 8362 5641 6003 7805 5604 9562 6004 8362 5821 5645 6005 5675 5607 5646 6441 6378 5609 4587 7805 5821 5675 5652 6009 6441 7804 5664 6010 7010 6259 5682 6378 7508 5614 7508 6013 7804 5615 7010 6015 4587 6259 6985 1458 2301 The Result should be as below Store R1 R2 R3 9562 2301 ---- 8352 8352 8362 ---- ---- 7805 ---- 9562 ---- 8362 5821 ---- ---- 5675 ---- ---- 6441 6378 ---- 4587 7805 5821 5675 ---- ---- 6441 7804 ---- ---- 7010 6259 ---- 6378 7508 ---- 7508 ---- 7804 ---- 7010 ---- 4587 6259 6985 1458 2301 Any help is appreciated Thank You Deepak See your other thread with the same question. Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |