Hi,
I have a column with patients names like this:
smith
taylor
taylor
taylor
garcia
garcia
williams
brent
I need to count the duplicates only once though (to equal 5 in this example). It's a pretty massive spreadsheet I'll be applying different filters to. I'm not advanced in Excel, so I'll need it explained in lamen's terms.
Thanks in advance,
Terry
Bookmarks