Excel "FIRST" Formula

[TopJack]

In Excel 2003 is there a formula that can find the first VISIBLE cell contents from a filtered AUTOFILTER list.

I want to use a command like "=FIRST(A2:A100)" and it will return the first cell that is showing from the filtered list regardless how its filtered (assuming of course some data is still showing).

I know this can be done in VBA but I was wondering if a formula could get the same results.

 

[SkipVought]

Hi,

Use the MATCH function to find the row offset for the filter value and the INDEX function for the column you are referencing to return the value, something like...
[tt]
=INDEX(TheReturnRange,MATCH(FilterValue,FilterRange,0),1)
[/tt]


Skip,

_[red][/red]

 

[TopJack]

Hiya Skip,

sounds good but how would I get the FilterValue ?

Thanks for responding.