T
Tinä
Hi,
I'm looking for a Formula to return the *most frequent * value in
Dynamic Named Range that will be filtered. I therefore, need th
Formula to include *only* the Visible cell values of the Dynamic Name
Range called RESULTS.
The Formula needs to :
1) Return the MOST frequent value in (Filtered Visible Cells) Range ;
2) Return the Number of Times this value appears in (Filtered Visibl
Cells) Range.
The Dynamic Named Range details for RESULTS in the Define Name Refer
To Box:
=OFFSET('SUBJECT'!$Q$9,2,0,COUNTA('SUBJECT'!$Q:$Q),1)
Thanks
Tin
I'm looking for a Formula to return the *most frequent * value in
Dynamic Named Range that will be filtered. I therefore, need th
Formula to include *only* the Visible cell values of the Dynamic Name
Range called RESULTS.
The Formula needs to :
1) Return the MOST frequent value in (Filtered Visible Cells) Range ;
2) Return the Number of Times this value appears in (Filtered Visibl
Cells) Range.
The Dynamic Named Range details for RESULTS in the Define Name Refer
To Box:
=OFFSET('SUBJECT'!$Q$9,2,0,COUNTA('SUBJECT'!$Q:$Q),1)
Thanks
Tin