On 16/12/2024
Group Data Table
| Id |
Group |
Name |
|
Group |
Count |
| 1 |
Group1 |
Dietrich |
|
Group1 |
3 |
| 2 |
Group1 |
toto |
|
Group2 |
2 |
| 3 |
Group1 |
titi |
|
Group3 |
1 |
| 4 |
Group2 |
nana |
|
|
|
| 5 |
Group2 |
popo |
|
|
|
| 6 |
Group3 |
pipi |
|
|
|
Unique value : =UNIQUE(B2:B7), for a specific sheet : =UNIQUE(Append1_1!F2:F337888)// here Append1_1 is the name of the sheet
Count unique value : =COUNTIF(B2:B7,F1)
| Group |
Count |
| Group1 |
3 |
| Group2 |
2 |
| Group3 |
1 |
Sum with two conditions
=ARRONDI(SOMME(SI((GAUCHE(G2:G18962;NBCAR(V18969))=V18969)*(W2:W18962<>"folder"); R2:R18962; 0)) / 1024 / 1024;2) & " MB"
Count rows with 2 conditions
=SOMMEPROD((GAUCHE(G2:G18962;NBCAR(V18969))=V18969)*(W2:W18962<>"folder"))
=SOMMEPROD((GAUCHE(G2:G18962;NBCAR(V18964))=V18964)*(W2:W18962="folder"))