LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nip Nip is offline
external usenet poster
 
Posts: 1
Default Count unique values based on multiple criteria

Hi,

I am trying to do something that should be simple but I can't figure this
out. I want to count the number of unique customers in a sheet if the month =
7, year = 2006, region=East and segment = Top.

Of course, all these criteria are columns with multiple values - segment
would have Top, middle, bottom, Region would have East, West, North, South
etc.

Thanks!


 
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
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 4 April 10th 06 10:35 PM
how to count unique values in excel based on multiple criteria IDBUGM Excel Worksheet Functions 3 March 15th 06 04:00 PM
count and display unique values joe Excel Worksheet Functions 2 December 19th 05 01:11 AM
Count of Unique values Richard Excel Worksheet Functions 3 September 27th 05 05:46 AM
Function to count unique values? Richard Buttrey Excel Worksheet Functions 5 September 22nd 05 02:58 PM


All times are GMT +1. The time now is 06:29 PM.

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

About Us

"It's about Microsoft Excel"