Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |