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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
You must log in or register to reply here.

Similar threads

Q
  • Question
Automate missing cell value report
Replies
2
Views
114
mumps
mumps
C
  • Question
Duplicates with different data to combine with VBA
Replies
2
Views
110
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
460
NateSC
NateSC
T
  • Solved
Populate three columns in list box from many columns based on selected date in combobox
Replies
2
Views
181
tubrak
T

Forum statistics

Threads
1,214,869
Messages
6,122,015
Members
449,060
Latest member
LinusJE

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