Help would be appreciated. It seems simple to me but I can't get it.
1 blue formula = 2 2 green 2 red 3 yellow 3 blue 4 cyan 5 magenta
The formula should equal two because there are two values in column A that have been repeated (2 and 3). What I need is a count of only non-unique values in Column A.
Bookmarks