Walter Jackson48, thanks a ton for fixing this!!!!
Thanks too, Kyle Johnson2, I'll check out this tutorial page later on. 😉
Thanks so much!
Thanks too, Kyle Johnson2, I'll check out this tutorial page later on. 😉
Thanks so much!
Home ›
Robin Fowler4 › Posts
Posts by Robin Fowler4
2 posts shown.
Need some Excel help
In column A, I have a fixed list of numbers from 1 to 30. These stay the same.
In column B, I want to enter any 5 numbers that I can change whenever I need—for example: 2, 6, 11, 16, 19.
I need column C to automatically show all the remaining numbers from column A in order: 1, 3, 4, 5, 7, 8, 9, 10, 12, 13, 14, 15, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30.
Which function should I use?
Thanks a lot for the help!
In column A, I have a fixed list of numbers from 1 to 30. These stay the same.
In column B, I want to enter any 5 numbers that I can change whenever I need—for example: 2, 6, 11, 16, 19.
I need column C to automatically show all the remaining numbers from column A in order: 1, 3, 4, 5, 7, 8, 9, 10, 12, 13, 14, 15, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30.
Which function should I use?
Thanks a lot for the help!