Forum Discussion
ggsmile4u
Dec 08, 2021Copper Contributor
How to show some results used in a function
I'm looking for some results using a function
With the same conditions
The function displays the appropriate first result
How can I view the second, third and fourth result? I have an excel 2016
Martin_Weiss
Dec 09, 2021Bronze Contributor
Hi ggsmile4u
if I understand correctly, there would be more results for your function, but it only delivers the first one.
Generally, in Excel 2016 it is tricky to do something like this, you probably need to use so-called array-functions.
To give you a better advice: Could you please upload an example of your file with the respective formulas?