Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract the first entry in a filtered list?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract the first entry in a filtered list?
How do I extract the first entry in a filtered list?
The archives do not look kindly on no text in the message. Put in subject line and ask a question. Try this where f2 is the first cell after the header text Sub firstinfiltered() MsgBox Range("f2:f21").SpecialCells(xlCellTypeVisible).Ce lls(1) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Djoy" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract the first entry in a filtered list?
Thank you very much for your help. The formula is what I needed. I'm also
grateful to all those who posted in response to my query. Kind regards. "T. Valko" wrote: 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 ... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I extract the first entry in a filtered list?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Djoy" wrote in message ... Thank you very much for your help. The formula is what I needed. I'm also grateful to all those who posted in response to my query. Kind regards. "T. Valko" wrote: 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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
Extract uniques from filtered range | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions |