Need forumul for counting lines of servers but not duplicates

Stormy4757 · #1 11-01-2013, 08:28 AM

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 those. I tried the “Remove Duplicates” under the Data Tab but it is greyed out. Why? Is there a simple way to do this?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting grid lines but keeping the axis lines	CoffeeNut	Excel	0	04-01-2013 01:50 PM
Counting Formula	Karen615	Excel	6	06-20-2011 07:19 PM
Counting Colors	g48dd	Excel	2	03-13-2011 09:28 PM
Counting Weeks	leroytrolley	Excel	1	08-18-2008 11:12 AM
sum of duplicates	zxmax	Excel	1	09-29-2006 08:29 PM