Filtered Cell Question

  • Thread starter Thread starter Bg
  • Start date Start date
B

Bg

I have a worksheet with 8 columns and 600+ rows of data. I have filters
enabled for all the columns. Column "A" is for last names. When I filter the
names in column "A", I will get about 10-20 last names. I would like to have
formula in cell A-10 that will use the last name that was filtered in column
"A".
Is that possible?

Thanks
Bg
 
To return the last text value in a filtered list, try...

=LOOKUP(2,1/SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),A2:A10)

Hope this helps!
 

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

Similar Threads

hidden rows problem 7
VBA to Filter on variable column 5
Help needed 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Filtering Using Values In A Specific Cell 3
Select rows which satisfy 2 criteria 16
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top