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:
Pisii pe Simpatie
 | Femeie
24 ani
Ialomita
cauta Barbat
24 - 44 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
I have a 3 lists of sectors, containing 5, 16 and 17 subsectors and I want to separated them into each of 3 categories with one formula.
This is done via IF and SUMPRODUCT. First I named each range of sectors as: LIST1, LIST2, LIST3. My data is in a table, that's why table references are seen in the formula (@). For LIST1 I want the formula to show A, for LIST2 to show B and for LIST3 to show C.
=IF(SUMPRODUCT(--([@[S/S]]=LIST1))>0;"A";IF(SUMPRODUCT(--([@[S/S]]=LIST2))>0;"B";"C"))
|
|
| pus acum 3 ani |
|