Forum Discussion
Got in over my head, now I need formulas to get the right data.
A program creates an excel spreadsheet that has 2 columns, I need to know out of the 51 possible location points in column A, which ones are missing. And list those in say column D. This sample is ob...
This is not a pristine solution, but assuming this is a one-off need, it works. And I'm also assuming, though you don't say it, that the 51 possible locations are numbered 001 through 051. I did it--I said it's not the most elegant or pristine solution--by simply changing the ones you DO have into numbers, and then creating a list of numbers 1 through 51 and using MATCH to identify the ones that do exist and, by their omission therefore, the ones that are missing.
A much cleaner solution could be devised, but as noted, I'm just giving you a quick and dirty,