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 |