Hello,
Finally after a lot of attempts, I managed to write an IF array formula that correctly does the analysis I wanted as shown in the figure below:
But sadly, it shows blank after hitting cntrl+shift+enter which I think is because the first result in the array is FALSE.
However, my intention for the formula was to show the first TRUE result which is "3", and only show blank if all results were FALSE. So, what is the general trick in the syntax of an IF array function to make it show the first TRUE result?
Thanks for any input!!!
P.S. My actual formula is extremely complicated and ugly ? but I can post it if needed. But hopefully the concept can be illustrated with any simple IF array function of the responder's choice.
Finally after a lot of attempts, I managed to write an IF array formula that correctly does the analysis I wanted as shown in the figure below:
But sadly, it shows blank after hitting cntrl+shift+enter which I think is because the first result in the array is FALSE.
However, my intention for the formula was to show the first TRUE result which is "3", and only show blank if all results were FALSE. So, what is the general trick in the syntax of an IF array function to make it show the first TRUE result?
Thanks for any input!!!
P.S. My actual formula is extremely complicated and ugly ? but I can post it if needed. But hopefully the concept can be illustrated with any simple IF array function of the responder's choice.