Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting cells with formula CF (not value CF)
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting cells with formula CF (not value CF)
No takers :(
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting cells with formula CF (not value CF)
I think the easiest solution would be to mimic that formula in a cell on the
same row. Working with Conditional Formatting ain't for the faint of heart: http://cpearson.com/excel/CFColors.htm (From Chip Pearson's site) jc wrote: No takers :( -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |