View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alan[_7_] Alan[_7_] is offline
external usenet poster
 
Posts: 1
Default Temporary Array i.e. match "this" and return entire row

I found the FREQUENCY formula which is great for counting entries by
date.

I want to add a condition to which rows FREQUENCY is counting.

My data table looks like

| Date | Name |
| Date | Name |
| Date | Name |

Results table is :

|- Date -| Name 1 | Name 2 | Name 3 | etc...
| Jul 01 | count | count | count |


My ideal formula where it says "count" is =FREQUENCY( array returned
IF (A1:B3 = "name1") )

Is this possible? Unfourtunetly the tradtional double criteria array
formulas of SUM, IF, SUMPRODUCT are way too slow when checking 10000 x
20 & 10000 x 20 rows for plain text. heh.

Thanks in advance!