Additional Criteria for If Statement

[dmill8023]

Hello all! I am looking for help on expanding the logic on an If function I have. I am looking to create my own unique identifier for my data based on similar data in different columns. For example I start in A2 putting 1 under ID. In A3 I enter the following formula

=IF(AND(G3=G2,J3=J2),A2,A2+1).

What this returns after I drag it down my entire data set if G3+G2 as well as J3+J2 (all the way down for their respective columns) is similar is a similar ID number to work with. I want to add another column to this scenario and have not been able to find the solution. Basically I would like to include - if possible - column B and maybe column C to this as well.

Does anyone know a solution for this??? Please help it will be appreciated.

 

[dreid1011]

What are the conditions for col B and C?

 

[dmill8023]

I'm basically trying to say if the values in G3+G2, J3+J2, and for example B3+B2 are all the same for their respective column give me the unique ID located in A

 

[dreid1011]

Then just add more to the AND( ).

=IF(AND(G3=G2,J3=J2,B3=B2),A2,A2+1)

 

[dmill8023]

Thank you dreid1011...that did it! I could've sworn I did that previously but obviously did not! THank you

 

[dreid1011]

You're welcome.