BubbaUnited
New Member
- Joined
- Jun 28, 2018
- Messages
- 1
Hi,
I am struggling with an array formula that will help me count the number of unique IDs in one column, that occurs when two criteria in two separate columns are met.
My current Array formula reads as below and works to count 1 criteria in one column and the unique values from another, column F.
I would like to extend this formula so that it checks two criteria, from two columns, are met and then returns the unique value in Column F.
=SUM(--(FREQUENCY(IF('RFA Overview'!$A:$A=$A5,MATCH('RFA Overview'!$F:$F,'RFA Overview'!$F:$F,0)),ROW('RFA Overview'!$F:$F)-ROW('RFA Overview'!$F$2)+1)>0))
[TABLE="width: 590"]
<colgroup><col><col span="8"></colgroup><tbody></tbody>[/TABLE]
Thanks
Bubba
I am struggling with an array formula that will help me count the number of unique IDs in one column, that occurs when two criteria in two separate columns are met.
My current Array formula reads as below and works to count 1 criteria in one column and the unique values from another, column F.
I would like to extend this formula so that it checks two criteria, from two columns, are met and then returns the unique value in Column F.
=SUM(--(FREQUENCY(IF('RFA Overview'!$A:$A=$A5,MATCH('RFA Overview'!$F:$F,'RFA Overview'!$F:$F,0)),ROW('RFA Overview'!$F:$F)-ROW('RFA Overview'!$F$2)+1)>0))
[TABLE="width: 590"]
<colgroup><col><col span="8"></colgroup><tbody></tbody>[/TABLE]
Thanks
Bubba