Missing numbers in different columns listing seperately

[YELUBOLUSURYA]

There are duplicate numbers and missing numbers in columns 1,2,3,..10 in a sheet(1 to 5000 in all columns) I want to list missing numbers seperately in a new column in the same sheet. Kindly give macros for this
Thanking U
SURYA

 

[Peter_SSs]

Welcome to the MrExcel board!

Could you give us a small set of sample dummy data and the expected results with XL2BB so that we understand better what you have tried to describe?

 

[YELUBOLUSURYA]

There are duplicate numbers and missing numbers in columns 1,2,3,..10 in a sheet(1 to 5000 in all columns) I want to list missing numbers seperately in a new column in the same sheet. Kindly give macros for this
Thanking U
SURYA

In the given sheet there are duplicates and missing numbers The total numbers are 1 to 68000. Kindly give vbaexcel macros to perform the list of missing numbers in a separate column in the same sheet

 

[Peter_SSs]

..

Welcome to the MrExcel board!

Could you give us a small set of sample dummy data and the expected results with XL2BB so that we understand better what you have tried to describe?

 

[YELUBOLUSURYA]

WHEN I CONVERTED THE DATASHEET TO XL2BB IT IS GIVING ERROR "OVERFLOW". i donot know how to reduce data
all the numbers in the cells ordinary numbers there are no calculation, or functions in the cells.

 

[Peter_SSs]

That is why I suggested making a small set of sample dummy data. We don't need 10 columns of 5000 numbers. What we need is to be able to set up a sheet in a similar manner to yours (not the same size) that demonstrates what you have, what you are trying to achieve and the results that you expect from it.

 

[YELUBOLUSURYA]

I created new sheet with less columns and less numbers for your information

 

[YELUBOLUSURYA]

The original document is added

 

[Peter_SSs]

I created new sheet with less columns and less numbers for your information

But you didn't post it with XL2BB.

.. and if you do post it with XL2BB make sure that the expected results are also included and you give any further clarification you can about how to (manually) get those expected results.

 

[YELUBOLUSURYA]

T

TEST DOCUMNET for MrEXCEL.xlsm
	A	B	C	D	E	F	G	H	I	J
1	1	535	438	239	478	941	935	284	560	560
2	2	535	438	218	616	668	995	259	563	639
3	3	535	439	239	668	309	935	239	560	560
4	4	31	439	256	415	941	935	239	560	560
5	5	535	439	417	154	668	935	284	784	563
6	6	535	439	644	154	994	378	236	639	560
7	8	535	439	644	941	880	489	285	639	560
8	9	535	439	644	668	942	666	285	560	619
9	11	535	439	644	697	227	587	259	560	560
10	15	535	438	644	669	995	655	260	639	560
11	16	535	438	644	696	149	571	261	639	259
12	17	535	438	644	941	292		260	560	563
13	29	535	438	782	697	849		260	639	563
14	30	535	438	782	415	849		239	560	560
15	40	149	611	539	539
16	5	149	791	546	546
17	60	211	611	539	539
18	70	149	171	539	539
19	80	149	872	546	539
20	90	149	971	539	546
21	120	149	579	546	539
22		539	941	539	539
23		546	149	539	539
24		539	176	539	539
25		546	870	539	539
26		546	267	539	539
27		539	240	539	539
Sheet1

he original document is added