Hi All
I am looking for a excel function, which would help me to count the number of cells in a given row which is higher the cells above it.
For e.g. I am comparing the cells in row #1 and #2 from Column A to Column L
I want to count the number of cells in #2, between 2A and 2L, that are having a value higher than its corresponding cells in #1 between 1A and 1L.
What function would I use.
Bookmarks