gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
- Mobile
I may be misunderstanding the arcane art of custom formula data validation. I have a column that should only accept the name of its tab as valid data. I use the formula:
The result is indeed what I am looking for from the formula, but when I use it as a custom data validation formula, it rejects the desired answer.
Excel Formula:
=MID(CELL("filename",D2), FIND("]",CELL("filename",D2))+1,100)
The result is indeed what I am looking for from the formula, but when I use it as a custom data validation formula, it rejects the desired answer.