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:
Ioana24 pe Simpatie.ro
 | Femeie
25 ani
Bucuresti
cauta Barbat
27 - 43 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 895
|
|
The following formula will spill top 4 (or less if less) suppliers from range J10:J71 with the highest 4 values in range N10:N71. If all values in N10:N71 are zero, it displays "all zero".
=LET(
top; 4;
suppliers; $J10:$J71;
values; N10:N71;
filtered; FILTER(HSTACK(suppliers; values); values>0);
sorted; SORTBY(filtered; INDEX(filtered;;2); -1);
result; TAKE(INDEX(sorted;;1); MIN(top; ROWS(sorted)));
IF(
NOT(ISERROR(result));
result;
IF(
AND(ISERROR(result); ERROR.TYPE(result)=14);
"all 0 or top=0";
result
)
)
) |
Source: ChatGPT
|
|
| pus acum 1 luna |
|