Hello!
I m looking for a macro that could loop through a number sequence (starting at any given number, so cant use the Rows function otherwise a formula would work).
and then if the sequence is broken i would like it to print the missing number(s) in a column.
See file attached.
Thankful for any help.
Best
Last edited by jheidens; 01-17-2018 at 03:08 PM. Reason: Better sample data
Try this.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Originally Posted by skywriter
Try this.
Please Login or Register to view this content.
Amazing, impressed!
Thank you Skywriter!
Try
Please Login or Register to view this content.
You guys are just amazing!Try
Please Login or Register to view this content.
Thanks alot Jindon it works perfect also with the column containing letters and numerical combined.
Jindon - i have tried to apply your script on another file with the same data but difference is that its a lot more data.
I have some files i need to apply it on with 350 000 records. It worked great on the file you uploaded. Unfortunately this is too high level VBA for me to adjust i'm more on a beginners level.
What happens is that i do get an error.
I will upload data and file which this occured on and would be very thankful if you could have a look at it?
Last edited by jheidens; 01-18-2018 at 08:32 AM.
Skywriter i have also tried your script on the last previously uploaded file and it tells me "subscript out of range" error.
Although it worked great on the file you uploaded!
Last edited by jheidens; 01-18-2018 at 08:31 AM.
Because your missing numbers exceeds the row limit i.e. 1048576.
Please Login or Register to view this content.
Amazing thank you!
Works like a charm now!
Edited
Last edited by jheidens; 01-18-2018 at 09:32 AM.
1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
2)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks