MrExcel MVP, Moderator
- May 28, 2005
- Office Version
No, fair enough.But that wasn't what they were asked to do, so don't be too hard on them
OK, given that (and lots more time to ponder) I now offer a modification of the stated solution that solves the "precise challenge" with just 30 characters. Still array-entered:... devise the shortest formula that they could, which would solve the precise challenge in front of them.