LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cash
 
Posts: n/a
Default Count unique entries

I am trying to count the number of unique entries in a column of data but
based on data in other columns. I need this to be automated versus filtering
the data and cut/pasting, etc. For example, if I want to know how many unique
entries in Column C are "2005, FEB" the answer I'm looking for is: 1

COL A COL B COL C
2006 JAN 3
2006 FEB 4
2005 FEB 5
2005 FEB 5
2005 JAN 5

Can one of your smart folks help me out?
 
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
"COUNTU" function in Excel to count unique entries in a range WayneL Excel Worksheet Functions 20 September 19th 08 03:50 AM
Count unique entries BeSmart Excel Worksheet Functions 7 August 30th 05 12:53 PM
Count of unique entries slang Excel Discussion (Misc queries) 4 July 3rd 05 06:45 AM
how to count unique entries with multiple condition Michael Excel Worksheet Functions 6 June 29th 05 12:38 PM
count duplicate (or, inversely, unique) entries, but based on a condition markx Excel Worksheet Functions 3 March 8th 05 06:57 PM


All times are GMT +1. The time now is 03:59 PM.

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

About Us

"It's about Microsoft Excel"