visible rowindex
 

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)

visible rowindex
 

On Aug 29, 12:19 pm, Chris wrote:
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

visible rowindex
 

On Aug 29, 1:59*pm, Spiky wrote:
On Aug 29, 12:19 pm, Chris wrote:

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

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

visible rowindex
 

On Aug 29, 11:03 pm, Chris wrote:
On Aug 29, 1:59 pm, Spiky wrote:

On Aug 29, 12:19 pm, Chris wrote:

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

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.