J
jc
I'm applying the following CF formula to data in a spreadsheet...
=AND(RC=MAX(RC1:RC4),COUNTIF(RC1:RC4,RC)=1)
This allows me to highlight the highest value in the row if it occurs
only once in that row.
What I now need at the bottom of each column, is a count of the number
of cells in that column which gave a TRUE result to the above formula.
Can it be done
I've found examples here where the CF is based upon a cell value but
not where the CF is formula based.
Thanks in advance
=AND(RC=MAX(RC1:RC4),COUNTIF(RC1:RC4,RC)=1)
This allows me to highlight the highest value in the row if it occurs
only once in that row.
What I now need at the bottom of each column, is a count of the number
of cells in that column which gave a TRUE result to the above formula.
Can it be done
I've found examples here where the CF is based upon a cell value but
not where the CF is formula based.
Thanks in advance