ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting cells with formula CF (not value CF) (https://www.excelbanter.com/excel-worksheet-functions/61452-counting-cells-formula-cf-not-value-cf.html)

jc

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


jc

Counting cells with formula CF (not value CF)
 
No takers :(


Dave Peterson

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


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com