Counting populated rows

Result.xlsx

Originally Posted by martindwilson

something like
=IF(A2="","",11-COUNTA($A$1:A2)) filled down maybe
or just i one cell put =MIN(MAX(0,10-COUNTA(A2:A5000)),10) which will count down to 0

Thanks for your response Martin

I've tried the filled down method, which works one the first run. Or rather, it works when directly entering data into the cell, but I'm actually using a data validation list to change the cell value. I presume this has something to do with a NULL value.

That's when the formula starts to behave oddly. i.e it counts down all cells, rather than just those with values.

I've created this in a worksheet. please see attached.Attachment 277669


Cheers