Can I Use a Count Function for Text?
On Jul 17, 11:17 pm, beckyd wrote:
I am trying to use the count function on text in a totally different way...
I want to put the word DUPE or some type of flag in one column based on
whether or not COUNTIF on a different column is greater than 1
So instead of having to eyeball a column to look for formatted columns
indicating that a conditional formula has been met, i'd like a way to use the
autofilter tool on a different column so that only (and all) rows with
duplicates display .. so i can work with just those.
thanks.
So, something like this. You'll have to modify the COUNTIF part.
=IF(COUNTIF($C$3:$C$100,C3)1,"DUPE","")
|