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()...
Okay, but you said an error is on Excel Desktop and you don't use Excel for web
SergeiBaklan Sir, strange same formula is working now, but not able to understand why it was not working then
If a is the text - when not.
- Very interesting. It looks like a *1 works, too.
As a comment, just + before reference/name is enough. Like
=EDATE( +range, n)
=T( +range )
- Thank you very much, 😃
Mayukh_Bhattacharya , you are welcome. Without knowing your environment I don't know what it was as well.
Nothing to do to close. If you have no more questions or comments related to the topic do nothing here. And you are welcome to open new thread if you have another new questions to community.
- Sir, even though its working now, but I am not able to figure what was the issue, anyways when its working, better not to take any more stress on it. Thank you very much for your time patience and effort. Sir how do i close the post.
Glad to know you sorted this out, thank you for the update.
