Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort & match
I have a 21 page sheet that I have to match and sort columns b & d. I sort by
column b and then by d, but when they do not match each other I am having to manually move each one. Is there any way for me to sort and match the columns? A B C D E 11/21/2006 83225185 $93.09 83225185 $93.09 11/21/2006 83225223 $190.23 83225223 $190.23 11/21/2006 83225969 $49.99 83225969 $49.99 11/21/2006 83225971 $49.66 83225971 $49.66 11/21/2006 83225983 $0.01 83225995 $89.99 11/21/2006 83225995 $89.99 83226579 $268.01 11/20/2006 83226579 $268.01 83226593 $41.17 11/20/2006 83226593 $41.17 83226605 $222.59 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort & match
-Hi Rae:
I assume that all the data is on one sheet and that it merely prints out on 21 pages. Why not sort columns A:C using two keys B and C B ascending C ascending and then D:E using two keys D and E D ascending E ascending This should match them up and then you can check using if(and(b1=d1,c1=e1),"","<<<") The one issue that you do not discuss is the relevance of the date. Does it matter that cells d and e are moved to another date? -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Rae" wrote: I have a 21 page sheet that I have to match and sort columns b & d. I sort by column b and then by d, but when they do not match each other I am having to manually move each one. Is there any way for me to sort and match the columns? A B C D E 11/21/2006 83225185 $93.09 83225185 $93.09 11/21/2006 83225223 $190.23 83225223 $190.23 11/21/2006 83225969 $49.99 83225969 $49.99 11/21/2006 83225971 $49.66 83225971 $49.66 11/21/2006 83225983 $0.01 83225995 $89.99 11/21/2006 83225995 $89.99 83226579 $268.01 11/20/2006 83226579 $268.01 83226593 $41.17 11/20/2006 83226593 $41.17 83226605 $222.59 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index and Match Formula | Excel Worksheet Functions | |||
How can I sort multiple times | Excel Worksheet Functions | |||
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
How to match sort and lineup 2 sets of data | Excel Worksheet Functions | |||
A sort of lookup or match | Excel Worksheet Functions |