I have an excel file with multiple sheets.
Column A represents names. The sheets will have varying numbers of names, for example, on sheet one there may be a "smith" in row 3, but because on sheet 2 there may be additional names, the same "smith" may be in row 5.
Column B depicts growth, represented by a 1 (growth), or a 0 (no growth).
I would like to create a formula on the second sheet that measures the first instance of growth by referencing sheet 1. If a name on sheet 2 grew (1 in column B), but already was present on sheet 1 with growth, I would like the formula to return 0 because growth had already been measured before. Otherwise, if a new name appears, I would like to carry over the number in column B of sheet 2.
This is somewhat difficult to articulate, but I would appreciate any assistance anyone can offer. Thanks!
Column A represents names. The sheets will have varying numbers of names, for example, on sheet one there may be a "smith" in row 3, but because on sheet 2 there may be additional names, the same "smith" may be in row 5.
Column B depicts growth, represented by a 1 (growth), or a 0 (no growth).
I would like to create a formula on the second sheet that measures the first instance of growth by referencing sheet 1. If a name on sheet 2 grew (1 in column B), but already was present on sheet 1 with growth, I would like the formula to return 0 because growth had already been measured before. Otherwise, if a new name appears, I would like to carry over the number in column B of sheet 2.
This is somewhat difficult to articulate, but I would appreciate any assistance anyone can offer. Thanks!