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 xxIRISxx
 | Femeie
25 ani
Timis
cauta Barbat
25 - 60 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
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
|
|
| |
|
