Hi buddy, it's been a while , hope you all doing fine here

I have a large table of numbers to be analyzed.


The values of the cells are in the range from 1 to 9999.
I have attached the partial of the table for your reference.

The table contains fixed 23 columns.
It grows one row everyday, new row will be added to the bottom of the table.
(The table contains duplicated numbers, just FYI.)

i would like to analyze from some latest 400 rows, and find out the list of missing numbers.

(A simple example to illustrate this case:
-my table has 10 rows, two columns. The range of values are 1 to 5. Analyzing at latest 5 rows, it consist of value 2,5,1,2,5,1,5,1,1,2.
-the result should be showing the missing numbers are 3 and 4)

Based on the situation, i might need to increase the number of rows to be analyzed.

(This case is similar to post 354874 on superuser. But my data contains more than one column, and its not sequential.)

Attached Files

msofficeforums.xlsx (84.3 KB, 10 views)

Issue resolved