Forum Discussion
Filtering unordered records
This post contains a number of solutions to a problem of sorting arbitrarily ordered colours to pick out distinct combinations. I start with the formula as it should be, which sadly gives r...
I like the definition of Shuffle prior to passing it as a parameter to MAKEARRAY (I am so conditioned to my own conventions that I had to rename it 'Shuffleλ').
As an aside, I downloaded a copy of my own problem definition file and reimplemented your formula in order to see it working step by step. On opening the file, it showed
The banner was a surprise, I have never seen this before.
At first glance, it might appear to be a request to feed data to the recently deployed Co-Pilot, but I see someone on Mr. Excel's forum reported seeing it back in January of this year. Did you choose to 'Select Cell'?
- I did wonder whether it was Co-Pilot related. The formula visible in the image was displayed as the result of clicking 'Select Cell'. What wasn't clear to me was whether I was being invited to provide further explanation or whether it is aimed at you and others to provide comments such as 'The author is well known for creating idiosyncratic formulas that are best ignored if one is to retain one's sanity'.
It looks like I've joined the club:
It appears after submitting the formula it's then added as a private post in the feedback forum.