Hi all,
hopefully a quick one.
In Excel 2003 I need to be able to count the number of times in two columns that value 1 is larger than value 2. So in my attachment C11 to C15 all equal 10 and D11 to D15 equal 5,10,15,20 & 5 respectively. In this case there are 2 occurances of Cx been greater than Dx and 3 occasions when Cx is greater or equal to Dx.
In my real world spreadsheet there can be anything up to 2000 rows to compare.
Can the count of all rows in column C being greater than column D be returned from a single equation?
Many thanks,
Sherlock99.
Bookmarks