T
Tinä
Hi,
Using the Formulae below, I can obtain the required data from the
Columns in a non-filtered state.
Column T:
=IF(COUNTIF($V$10:$V10,$V11),COUNTA(INDIRECT("V"&U11+1&":V"&ROW()))-1,COUNTA($V$10:$V10))
Column U (helper column):
=MAX(IF($V$10:$V10=$V11,ROW($V$10:$V10)))
Column V:
Text Data
However, I also need to retrieve filtered data, and so require Formulae
that will take into account Filtered Visible Cells and not the
Non-Filtered data in the columns.
Can the formulae be adapted to work on Filtered Visible Cells.
Thanks
Tinä
Using the Formulae below, I can obtain the required data from the
Columns in a non-filtered state.
Column T:
=IF(COUNTIF($V$10:$V10,$V11),COUNTA(INDIRECT("V"&U11+1&":V"&ROW()))-1,COUNTA($V$10:$V10))
Column U (helper column):
=MAX(IF($V$10:$V10=$V11,ROW($V$10:$V10)))
Column V:
Text Data
However, I also need to retrieve filtered data, and so require Formulae
that will take into account Filtered Visible Cells and not the
Non-Filtered data in the columns.
Can the formulae be adapted to work on Filtered Visible Cells.
Thanks
Tinä