ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MISSING NUMBERS IN LIST (https://www.excelbanter.com/excel-discussion-misc-queries/118358-missing-numbers-list.html)

jpfrmnm

MISSING NUMBERS IN LIST
 
How do i find the missing numbers in a list. I have too many to do by hand.
I would like to place them in separate column. I found a macro in another
persons question, but it won't work- keep getting error message. Thanks for
any and all help.

Biff

MISSING NUMBERS IN LIST
 
How about posting some details.

What's the starting number? What's the ending number? Where are the numbers?
Where do you want the missing numbers listed?

Biff

"jpfrmnm" wrote in message
...
How do i find the missing numbers in a list. I have too many to do by
hand.
I would like to place them in separate column. I found a macro in another
persons question, but it won't work- keep getting error message. Thanks
for
any and all help.




Niek Otten

MISSING NUMBERS IN LIST
 
And what about the macro you found? What does it look like? What error message?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Biff" wrote in message ...
| How about posting some details.
|
| What's the starting number? What's the ending number? Where are the numbers?
| Where do you want the missing numbers listed?
|
| Biff
|
| "jpfrmnm" wrote in message
| ...
| How do i find the missing numbers in a list. I have too many to do by
| hand.
| I would like to place them in separate column. I found a macro in another
| persons question, but it won't work- keep getting error message. Thanks
| for
| any and all help.
|
|




All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com