Forum Discussion

ggsmile4u's avatar
ggsmile4u
Copper Contributor
Dec 08, 2021

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
excel
Formulas and Functions

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Dec 09, 2021

    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?

Resources