Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 data set
Please help to provide a formula when compare A to B with results in col C.
Data example A B Results C 1 2 Lower 2 2 No Change 3 2 Higher -- TouchTone Support |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 data set
Try this in C1 and drag down.
=IF(B1A1,"Higher",IF(B2<A1,"Lower","No Change")) Mike "TouchTone" wrote: Please help to provide a formula when compare A to B with results in col C. Data example A B Results C 1 2 Lower 2 2 No Change 3 2 Higher -- TouchTone Support |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 data set
Thanks, it work.
-- TouchTone Support "Mike H" wrote: Try this in C1 and drag down. =IF(B1A1,"Higher",IF(B2<A1,"Lower","No Change")) Mike "TouchTone" wrote: Please help to provide a formula when compare A to B with results in col C. Data example A B Results C 1 2 Lower 2 2 No Change 3 2 Higher -- TouchTone Support |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 data set
I assume there's a typo there in that B2 should presumably be B1? I guess
that what Mike intended was: =IF(B1A1,"Higher",IF(B1<A1,"Lower","No Change")) But then the OP wanted the answers the other way round (A higher than B, not B higher than A), so: =IF(A1B1,"Higher",IF(A1<B1,"Lower","No Change")) -- David Biddulph "Mike H" wrote in message ... Try this in C1 and drag down. =IF(B1A1,"Higher",IF(B2<A1,"Lower","No Change")) "TouchTone" wrote: Please help to provide a formula when compare A to B with results in col C. Data example A B Results C 1 2 Lower 2 2 No Change 3 2 Higher |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data | Excel Discussion (Misc queries) | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
Compare Data | Excel Discussion (Misc queries) | |||
COMPARE DATA FOR CHANGES | Excel Worksheet Functions |