Hi all,
I have a tight deadline and was wondering if anyone knows how to write a forumula for me.
I have a spreadsheet containing 62,293 lines of data. In column A I have the names of servers. I need a count of these servers, but some are duplicates. Obviously I don't want to count them. Is there a simple way to do this? And, yes I have filtered this sheet to only show data for the month of September, but that shouldn't make any difference.