T
Tinä
Hi Aladin,
Thank you for assistance. Unfortunately, the formula is not retrievin
the correct results.
The formulae below tells me how frequently the ROOMS are being used b
different Groups and how long they have not used them. The formula
works ok on non-filtered data but when I use Autofilter the results ar
not as they should be, because the results also include the non-filtere
data rather than just the Filtered Visible Cells.
Using the Formulae below, I can obtain the required data from th
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
Further help appreciated.
Thanks
Tinä
Thank you for assistance. Unfortunately, the formula is not retrievin
the correct results.
The formulae below tells me how frequently the ROOMS are being used b
different Groups and how long they have not used them. The formula
works ok on non-filtered data but when I use Autofilter the results ar
not as they should be, because the results also include the non-filtere
data rather than just the Filtered Visible Cells.
Using the Formulae below, I can obtain the required data from th
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
Further help appreciated.
Thanks
Tinä