Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |