Missing numbers in different columns listing seperately

Y

YELUBOLUSURYA

New Member
Joined
Oct 19, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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
 
Sort by date Sort by votes
Great, thanks. (y)
Now can you explain in that sheet, which is the original data and which are the results and explain how you manually got the results?
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

Q
  • Question
Automate missing cell value report
Replies
2
Views
133
mumps
mumps
C
  • Question
Duplicates with different data to combine with VBA
Replies
2
Views
149
chipsworld
C
2
  • Solved
VBA for removing extra characters in Barcode scanning
2 3 4
Replies
39
Views
1K
2KGrafix
2
B
  • Question
Need formula help
2
Replies
10
Views
482
NateSC
NateSC
T
  • Solved
Populate three columns in list box from many columns based on selected date in combobox
Replies
2
Views
191
tubrak
T

Forum statistics

Threads
1,215,474
Messages
6,125,024
Members
449,204
Latest member
LKN2GO

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top