Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Temporary Array i.e. match "this" and return entire row
I don't understand your "10000 x 20 & 10000 x 20 rows" reference.
I think pivot tables would do what you want, but not without knowing more about your format "Alan" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How to "return" the array element number in VBA | Excel Discussion (Misc queries) | |||
Search a random array of cells and return a value of "X" | Excel Worksheet Functions | |||
Using 'if" To Return An Entire Row? | Excel Discussion (Misc queries) |