How do I extract the first entry in a filtered list?
Try this...
Assuming the full range is A2:A15
Array entered** :
=INDEX(A2:A15,MATCH(1,SUBTOTAL(3,OFFSET(A2:A15,,,R OW(A2:A15)-MIN(ROW(A2:A15))+1)),0))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"Djoy" wrote in message
...
|