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()...
Are you on Excel Desktop or Excel for Web? If the latest, which regional settings do you use?
If you open the file attached to the previous post do you have errors? I have no ones in both sheets.
Sir its not working both places Excel Desktop as well as in Web. Sir workbook is editable mode
If your own file, try to re-enter formula (F2->Enter)
- Sir i did that sir. As you can see newer functions like take and textsplit are working but this one suddenly not working. I have raised the issue with ms support they are also confused not able to find a solution
Did you open file attached to the post or your own file?
- Yes sir the one which you posted it shows me Name error
If #NAME? error most probably you have no such function in your version of Excel.
Do I understand correctly you DO NOT use Excel for web and work in Excel Desktop? If so, which version / channel?