![]() |
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 |
Counting cells with formula CF (not value CF)
No takers :(
|
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