Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Criteria count

I'm having a major headache over a criteria count that I cannot figure out...
Maybe someone would have a solution for me.

I have two columns of data.
A1:A50 contains time slots that may repeat an undefinite amount of times.
B1:B50 contains various names that may or may not repeat

I need to count the number of different names that appears for a specific
time slots.

Here's an example:
7:00 Apple
7:00 Apple
7:00 Carrot
7:00 Peach
7:30 Cake
7:30 Carrot
7:30 Cake

Results should be:
7:00 3
7:30 2

I was thinking that an array formula would do the trick but I just can't
figure out how do it...

Thanks for any help you may provide me with.
 
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 using criteria ferde Excel Discussion (Misc queries) 4 March 21st 07 04:01 PM
How to count nos. on 3 criteria Excel_Learner Excel Worksheet Functions 5 August 28th 06 03:17 PM
Count If 3 Criteria Met kieffer Excel Worksheet Functions 9 April 15th 06 12:38 AM
COUNT IF - MULTIPLE CRITERIA Matthew Excel Worksheet Functions 2 January 9th 06 12:52 PM
Sum Count of Criteria Every 3rd Row Sam via OfficeKB.com Excel Worksheet Functions 5 December 11th 05 02:21 AM


All times are GMT +1. The time now is 09:33 AM.

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"