I am sure this is an easy one,
I want to count a cell entry if it is greater than or equal to an entry in a cell on the same row for example
a1 to a6 have percentage figures as do c1 to c6,
99.75 341 100.00
99.50 5946 99.93
99.75 26020 99.67
99.75 26090 99.67
100.00 25802 99.68
100.00 40134 99.50
I would expect a count of '2' for the above as only 2 cells in the range c1 to c6 are greater than or equal to the entry in column a on that same row. Does that make sense?
John.
I want to count a cell entry if it is greater than or equal to an entry in a cell on the same row for example
a1 to a6 have percentage figures as do c1 to c6,
99.75 341 100.00
99.50 5946 99.93
99.75 26020 99.67
99.75 26090 99.67
100.00 25802 99.68
100.00 40134 99.50
I would expect a count of '2' for the above as only 2 cells in the range c1 to c6 are greater than or equal to the entry in column a on that same row. Does that make sense?
John.