Hi
What i am trying to do is type the first number in Column E where the yellow is and drag it down. If the number dupes in Column D like you can see the 3 and 6 and others. I need the number to stay the same before it changes and goes higher. The number in E2 will always be different every time I do it and scroll down.
Was thinking either a formula starting below cell E2 at E3 so it knows the number to start above it at E2 or maybe a small macro pop up box and enter the number 7500 and it scrolls down to do what I am trying to do
Any help
Excel 2016 (Windows) 32 bit
What i am trying to do is type the first number in Column E where the yellow is and drag it down. If the number dupes in Column D like you can see the 3 and 6 and others. I need the number to stay the same before it changes and goes higher. The number in E2 will always be different every time I do it and scroll down.
Was thinking either a formula starting below cell E2 at E3 so it knows the number to start above it at E2 or maybe a small macro pop up box and enter the number 7500 and it scrolls down to do what I am trying to do
Any help
Excel 2016 (Windows) 32 bit
D | E | |
---|---|---|
1 | Id | number |
2 | 23 | 7500 |
3 | 24 | 7501 |
4 | 26 | 7502 |
5 | 2 | 7503 |
6 | 3 | 7504 |
7 | 3 | 7504 |
8 | 6 | 7505 |
9 | 6 | 7505 |
10 | 2 | 7506 |
11 | 1 | 7507 |
12 | 1 | 7507 |
13 | 5 | 7508 |
14 | 5 | 7508 |
15 | 6 | 7509 |
16 | 6 | 7509 |
Sheet: Sheet1 |
Last edited: