I have provided a simplified example below, which I will reference in my explanation.
What I am attempting to do is have Column B return the first value in Column D (in this case 10) and repeat this until it encounters the initial Animal again (cat). Once the next instance of "cat" is encountered, Column B will begin to return the next value in Column D (in this case 25).
So the following formula is what I'm attempting to use:
=IF(A2="cat",OFFSET(D2,0,0),0)
I know what I need it to do...I need the bolded 0 to increase by 1 every time "cat" is encountered in Column A. And I also need the FALSE condition to return the correct value that corresponds to that instance of "cat".....I just don't know how to do that in Excel speak.
Thanks in advance!
example.PNG
Bookmarks