Oct 11 2020 05:57 AM
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
Oct 11 2020 07:10 AM
SolutionIn 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
Oct 11 2020 08:56 AM
Perfect, thank you @Sergei Baklan
Oct 11 2020 09:20 AM
@Geir Hogstad , you are welcome
Oct 11 2020 07:10 AM
SolutionIn 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