Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 10, 09:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 137
Default how do i get an unduplicated count when my cells are names

My staff use Excel to keep a database of people who come to us for service.
Every 90 days the person can use our service again. At the end of the year I
want to know how many people (unduplicated) used our service. How do I do
that?
Thank you.

  #2   Report Post  
Old January 13th 10, 11:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default how do i get an unduplicated count when my cells are names

Enter this formula in cell below your list of names.

=SUBTOTAL(3,range) where range is your range of names including
duplicates.

Use Advanced Filter to return just the unique names filtered in place.

The subtotal will count filtered names.


Gord Dibben MS Excel MVP


On Wed, 13 Jan 2010 12:57:10 -0800, Brenda
wrote:

My staff use Excel to keep a database of people who come to us for service.
Every 90 days the person can use our service again. At the end of the year I
want to know how many people (unduplicated) used our service. How do I do
that?
Thank you.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Names NOT #N/A Dax Arroway Excel Worksheet Functions 2 November 19th 08 12:07 AM
Count Names relo Excel Worksheet Functions 7 August 8th 07 07:42 PM
Count Names mudraker Excel Worksheet Functions 2 June 22nd 06 09:21 AM
Count Names Diana Excel Discussion (Misc queries) 3 September 22nd 05 06:00 PM
Count names Farrel Excel Worksheet Functions 4 July 14th 05 08:50 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017