- Oct 2, 2008
- Office Version
I have my data as shown above in column A & B respectively. I want a formula to be put "C1". if any of the value in column B1:B10 is greater than Column A1:A10 respectively then it should return as "Greater". (for e.g. if B1>A1 or B2>A2, and so on. Also, for A11 to A15 I am using the sum amount to compare as shown in bold in below formula. Currently I am using the below formula which becomes very big if applied for 10 rows. Please help with a better formula.