Find missing numbers and post.

[johnny1r]

Hello everyone and thanks ahead for your help! I am using Excel 2016 and in my spreadsheet, in column A starting in cell A1 I have sorted numbers from 1 to 1000, no duplicates and no blank cells and no data beyond last number. There are however missing numbers. I would like Excel to when I press an activate combo keys to find those missing numbers and paste them in Column C starting in cell C1. I had this macro or code, I think, many years ago using Excel 2000 but it has long since been lost to me and I would like to use again. Thanks again for you help. Johnny1r

 

[Logit]

https://www.mrexcel.com/forum/gener...3-how-detect-missing-numbers-within-list.html

 

[johnny1r]

Thank You very much!!!

 

[Logit]

.
You are welcome