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
|