Hi ,
Hope you r doing well.can any one help out me in the following issue,(soon response will be highly appreciated)
I need to get a unique numeric values to a column1 based upon checking the conditions (whether the column is unique are not) on other 3 columns.
If any one the values or text from 3 columns are different compared to its upper column the a new numeric value(next) should be assigned to the first column.
Example:
columnA ColumnB ColumnC ColumnD
1 set bet tet
1 set bet tet
2 set yet tet
3 not at done
I have used the follwing formula but its only comparing 1 column and my req is it should compare other 2 columns as well and then assign a numeric value
Iam assigning a value 1 to the 1st record of column A(A1) and then from the second record (A2) iam using this formula
=IF(COUNTIF($B$2:B2,B2)=1,MAX($A$1:A1)+1,MAX($A$1:A1)) [Iam getting correct results but only comparing columnB and i need comparision of Column c,D as well)
Bookmarks