T
Tinä
Hi Frank,
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.
Desired Result is to have a formula that can return the correct result
using 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
Thanks
Tinä
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.
Desired Result is to have a formula that can return the correct result
using 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
Thanks
Tinä