Search code examples
countgoogle-sheets-formulauniquecountingcountif

IF Duplicate more than 1 counted as 1

all

I have list as below :

Apple
Orange
Grape 
Grape
Grape

I use formula : =AND((COUNTIF(A1:A,A1)>1),NOT(ISBLANK(A1))). How do I approach if I want grape also appear in the list?

Solution

  • try perhaps:

    =UNIQUE(A1:A)

    this will give you all unique values with no duplicates