View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 13
Default Grabbing the filtered data in a list?

I have a table that I have turned into a list. I narrow down the table
by choosing what to show in the header drop downs until I just have one
row of data showing.

How can I grab the numbers that are showing after I have chosen the
selected data in each column? The list seems to hide the non-matching
rows but I can't figure out how to reference just the remaining row of
data.

Any ideas?