Forum Discussion
Excel formula to determine missing numbers
An alternative could be Power Query which works in Excel 2013 and in newer versions. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.
You made this extremely helpful & somehow I have messed it up. I copied your work, but i keep getting an error message. No doubt some basic human error on my part, but I admit my skills with Power Query aren't quite up to par, as they should. Since I can't attach a 'clean' copy of my sheets for reference, I've included the screenshots.