|
|
#1
11-01-2013, 08:28 AM
|
|||
|
|||
Need forumul for counting lines of servers but not duplicates
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode