IF COUNTIF & COUNTA on Filtered Visible Cells

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ä
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top