Der Vortrag „Microsoft Excel 365 Advanced: Exercise 03“ von Simon Sez IT ist Bestandteil des Kurses „Microsoft Excel 365 – Advanced Lookup and Reference Functions (EN)“.
TRUE or FALSE: We can return the correct result when there are duplicates in the dataset by creating a unique identifier for each row.
Which argument of XLOOKUP gets replaced with the second XLOOKUP when looking up multiple values?
5 Sterne |
|
5 |
4 Sterne |
|
0 |
3 Sterne |
|
0 |
2 Sterne |
|
0 |
1 Stern |
|
0 |