View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark T. Mark T. is offline
external usenet poster
 
Posts: 5
Default Referncing Rows of Filtered Data

I need an Index() function that works against filtered data. I have filtered
data and I want to be able to reference row 3, column 4 of the filtered data
only using the Index() funtion. The regular Index () function goes against
all data, even rows hiden by the filter. Can any provide a solution?

Thanks,
-Mark