You can pass “<>” (including the quotes) as the parameter for criteria. This basically says, as long as its not empty/blank, count it. I believe this is what you want. =COUNTIF(A1:A10, “<>”) Otherwise you can use CountA as Scott suggests
There may be a more eloquent way, but this is the way I came up with: The function to find the last populated cell in a column is: =INDEX( FILTER( A:A ; NOT( ISBLANK( A:A ) ) ) ; ROWS( FILTER( A:A ; NOT( ISBLANK( A:A ) ) ) ) ) So if you combine … Read more
Try this: Select the whole column Click Format Click Conditional formatting Click Add another rule (or edit the existing/default one) Set Format cells if to: Custom formula is Set value to: =countif(A:A,A1)>1 (or change A to your chosen column) Set the formatting style. Ensure the range applies to your column (e.g., A1:A100). Click Done Anything … Read more
Note: when it says “B5” in the explanation below, it actually means “B{current_row}”, so for C5 it’s B5, for C6 it’s B6 and so on. Unless you specify $B$5 – then you refer to one specific cell. This is supported in Google Sheets as of 2015: https://support.google.com/drive/answer/78413#formulas In your case, you will need to set … Read more