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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
geogeorgiana17
 | Femeie
25 ani
Arad
cauta Barbat
26 - 57 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 916
|
|
I know there are multiple solutions for this, and here is one of these solutions below.
What I want is to make a dashboard based on yearly data structured in a specific way (not as tables).
=INDEX(
FILTER(RAW!$D$7:$Y$1000;
(RAW!$A$7:$A$1000=C$3)*
(RAW!$C$7:$C$1000=$B6));
1;
MATCH($B$3;RAW!$D$5:$Y$5;0)
) |
where
$D$7:$Y$1000 - contains the data I want to retrieve
$A$7:$A$1000 - contains year
$C$7:$C$1000 - contains parameter
$D$5:$Y$5 - contains company name |
The FILTER function results in a spill, and the INDEX-MATCH picks the value in the spill corresponding to the company selected in B3.
Source: ChatGPT
Others - untested for the above purpose, but might work:
DOUBLEXLOOKUP - LAMBDA function by Excel off the Grid
SUPERXLOOKUP - LAMBDA function by Excel off the Grid
|
|
| pus acum 2 saptamani |
|