Forum Discussion
Why does REDUCE Function gives VALUE Error
So I am trying to extract the cities from the string, though I have resolved the issue, with an alternative formula, but my reason to ask this query, is that, I was earlier trying to use the REDUCE()...
Tested here:
Excel web - OK
Excel desktop - OK
No #VALUE! errors. Using comma as list separator.
I do recall something vaguely similar with a simple MAP formula that was producing a #VALUE! error. I thought maybe I was spending too much time looking at the screen because the formula had been working then broke on re-calc. Haven't seen that one come back.