Forum Discussion
Solved
Get the filtered/selected value from a table.
Hi,
The goal here is to use Slice to select a value and get that value, so I can use it in other formulas.
See the attached sheet for example, explanation.
Best Regards
- Geir
In Excel two functions take hided content into account, SUBTOTAL() and AGGREGATE(). You may add helper column as here
in which function
=AGGREGATE(3,3,[@Kode])returns 0 or 1 depend on row is filtered or not. To return first filtered value we may use
=INDEX([Kode],MATCH(1,[IsNotFiltered],0))Result will be like
3 Replies
In Excel two functions take hided content into account, SUBTOTAL() and AGGREGATE(). You may add helper column as here
in which function
=AGGREGATE(3,3,[@Kode])returns 0 or 1 depend on row is filtered or not. To return first filtered value we may use
=INDEX([Kode],MATCH(1,[IsNotFiltered],0))Result will be like
Perfect, thank you SergeiBaklan
Hogstad_Raadgivning , you are welcome
