View Single Post
  #3   Report Post  
bj
 
Posts: n/a
Default

There is not a function which will do it directly, but there are ways of
doing what you want if I am reading your question properly.

to find the row
=min(if(range<filter criteria,1e6,row(range))
entered as array (Control-shift-enter)
will find the first row which would not be filtered out


"Eric" wrote:

Is there a worksheet function that can lookup the first value in a column in
a list that has been filtered?

In all cases the value will have been part of the filter, but done through
an autofilter (not an advanced filter).

Thanks, Eric