Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-01-2013, 09:33 AM
BobBridges's Avatar
BobBridges BobBridges is offline Need forumul for counting lines of servers but not duplicates Windows 7 64bit Need forumul for counting lines of servers but not duplicates Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I've only recently graduated from Excel 2003 to 2010, so I haven't yet tried the "remove duplicates" feature. But the way I'd get a count is this:

1) Sort on the server name.

2) In a column somewhere to the right—say X—make a simple formula: "A2=A1".

That's assuming the server name is in column A; use whichever column is appropriate. It's also assuming that there's one header row at the top, that the server names start in row 2. Now column X has a series of True and False values; it's False wherever the server name is not identical to the one above it (in other words this is a new server), and True if it's the same. All the Trues are duplicate, you see. So:

3) At the bottom of column X, use a COUNTIF function to count the False values, something like "=COUNTIF(X2:X62294,FALSE)".

How's that?
Reply With Quote
 



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
Need forumul for counting lines of servers but not duplicates Counting Formula Karen615 Excel 6 06-20-2011 07:19 PM
Need forumul for counting lines of servers but not duplicates Counting Colors g48dd Excel 2 03-13-2011 09:28 PM
Need forumul for counting lines of servers but not duplicates Counting Weeks leroytrolley Excel 1 08-18-2008 11:12 AM
Need forumul for counting lines of servers but not duplicates sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft