Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was wondering if there is some way that I can match or do an if then
function to match data from columns. For Instance if you had: One set of columns another set of columns A B C D E F Style WTD MTD Style OH OO 145 5 19 153 7 12 150 6 12 154 5 9 153 5 10 150 4 9 I would like to see if I can sort the first set and say if style from column A = column D then move E and F. Does this make any sense? Sorry it is difficult to explain but I get selling information from a company on 2 different reports and there are 100's of styles if I could match them in some other way it would be helpful. Currently I sort by style # and then cut and paste until everything matches and that takes a lot of time. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A 2-Column Matching Sort | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching data from column b | Excel Worksheet Functions | |||
Matching data in one column to another | Excel Worksheet Functions |