Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Oct 11, 2020
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  
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 11, 2020

    Hogstad_Raadgivning 

    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

Resources