quickly search most item that appear in an autofiltered table

Add a helper column and count the entries, then check/filter that for the highest

hi,

thanks for the reply

edit:
so i figured out how to get the unique item names in a helper column by DATA --> Advanced Filter --> check box unique records only -- into column F

then I found out about the COUNTIFS function and use a formula in column G that uses the range in list of column C and the criteria in column F
ex:
range in C is C2:C25
formula in G is COUNTIF($C$2:$C$25,F2) -- retain the $ sign so the range wont change when copied to other rows in G

Great work!!

You could also probably have used a countif in the helper as well, to keep it dynamic

Something like this, assuming your data is in col B

=if(countif($B$2:B2,B2)>1,0,1)
copied down

This will create a list of 1's (unique values) and 0's (duplicate values)

Let me know how you make out if you try that approach

The 2nd formula is being used to ID unique records, while the 1st formula (if I understand you correctly) is counting those unique records, and as such, should probable be...
COUNTIF($B$2:$B$25,1)

Come to think of it, if all you really need to do is count unique records, maybe this...
F2=if(countif($B$2:B2,B2)>1,0,1)+F1
copied down

You would then just need to either just reference the last cell in that helper, or use MAX() on the helper