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.
=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.