visible rowindex

[Chris]

Is there any possible way to change this formula to only use the
visible rows so I can filter my list?

=INDIRECT("PrintData!B" &RowIndex)

 

[Spiky]

Is there any possible way to change this formula to only use the
visible rows so I can filter my list?

=INDIRECT("PrintData!B" &RowIndex)

Use SUBTOTAL wrapped around it. To be safe, use the 10x version of the
first argument. IE:
not SUBTOTAL(9,A1:A10) which will only ignore cells hidden by a filter
use SUBTOTAL(109,A1:A10) which will ignore all hidden cells

 

[Chris]

Use SUBTOTAL wrapped around it. To be safe, use the 10x version of the
first argument. IE:
not SUBTOTAL(9,A1:A10) which will only ignore cells hidden by a filter
use SUBTOTAL(109,A1:A10) which will ignore all hidden cells

I can't get this to work in the right formula context. Can you help me
with the formula?

 

[Spiky]

I can't get this to work in the right formula context. Can you help me
with the formula?

Well, I don't have much info from you. I was thinking:
=SUBTOTAL(109,INDIRECT("PrintData!B"&RowIndex&":"&"PrintData!B"
&RowIndex))

I think that should work, but you'll have to put in your reference in
the Indirect function. If you don't know how Subtotal works, look it
up in Help. There are several calculations it can perform, you change
the "109" to the one you need. Help lists the options.