#1
|
|||
|
|||
Find missing numbers from a table
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.) |
#2
|
|||
|
|||
Issue resolved
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
missing some page numbers only those contain object from excel | imeff | Word | 5 | 06-25-2015 01:12 AM |
find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |
Charts -Missing Titles and Axis Numbers | apolloman | Excel | 2 | 02-07-2012 05:05 AM |
Numbers Missing-HELP! | ofriendasu | Word | 0 | 07-12-2010 03:08 PM |