visible rowindex

C

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)
 
S

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
 
C

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?
 
S

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.
 

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