Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
Profil Diana2019

Femeie
25 ani
Vaslui
cauta Barbat
25 - 80 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Extract Filtered Slicer Value

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

The following formula requires Office 365 or Office 2021 to work.

It will extract the value of the slicer selection:
=INDEX(FILTER(tb8Query[Main group EN];SUBTOTAL(103;OFFSET(tb8Query[Main group EN];ROW(tb8Query[Main group EN])-MIN(ROW(tb8Query[Main group EN]));0;1)));1)

If multiple selections are made in slicer, it will extract the first value in an up - down direction.

Mrrrr
AdMiN
Postari: 2388

Alternative for Excel 2024 and Excel 365:
=INDEX(FILTER(tb8Query[Main group EN];BYROW(tb8Query[Main group EN]; LAMBDA(row; SUBTOTAL(3; row))));1;0)

Source: https://www.youtube.com/watch?v=Ru32mkEP8wc

_______________________________________

TRaP
Moderator
Postari: 960

The following might also work. It's used to extract values of visible cells:

=UNIQUE(FILTER(W2:W5072; BYROW(W2:W5072; LAMBDA(r; SUBTOTAL(103; r)))))

Pagini: 1

Mergi la