0

i want to change values when id values changes to different in excel like this

ID ChangedId
8 1
8 1
8 1
22 2
22 2
25 3

Any help will be thankfull.

Improve this question
1
  • Welcome to SuperUser! We are not a free coding service, so unless you have already tried something that didn't work, and you want to find out why, you will probably not get an answer here.
    – DarkDiamond
    Commented Jun 28, 2022 at 8:13

1 Answer 1

Reset to default
0

Try this formula:

=IFERROR(VLOOKUP(A2,IF({1,0},A$1:A1,B$1:B1),2,0),MAX(B$1:B1)+1)

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .