Formula Help ?

[zone709]

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
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td]Id[/td][td]number[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td]

23​

[/td][td=bgcolor:#FFFF00]

7500​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]

24​

[/td][td]

7501​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]

26​

[/td][td]

7502​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td]

2​

[/td][td]

7503​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td]

3​

[/td][td]

7504​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]

3​

[/td][td]

7504​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]

6​

[/td][td]

7505​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td]

6​

[/td][td]

7505​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td]

2​

[/td][td]

7506​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td]

1​

[/td][td]

7507​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td]

1​

[/td][td]

7507​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

13​

[/td][td]

5​

[/td][td]

7508​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

14​

[/td][td]

5​

[/td][td]

7508​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

15​

[/td][td]

6​

[/td][td]

7509​

[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

16​

[/td][td]

6​

[/td][td]

7509​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[jtakw]

Hi,

Formula in E2 copied down.

Book1
	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
Sheet334

Cell Formulas
Range	Formula
E3	=IF(D3=D2,E2,E2+1)

 

[zone709]

Works thanks for the reply and help. This helps alot

 

[jtakw]

You're welcome, and I guess you realize my typo,

Formula in E2 copied down.

I meant in E3 copied down.

 

[zone709]

You're welcome, and I guess you realize my typo,

I meant in E3 copied down.

Yes i relized it thanks.