Adding a column with variables for specific entries

Hi Andy,


Copy this formula to the column O,first row and drag upto whatever range you want.

   =CONCATENATE(A1,C1,D1)    

then in column 5(column E) drag the below formula upto whatever range you want.

     =COUNTIF($O$1:$O11,O1)     

i think the value you want will be filled in the column 5.

Reply to the post if this really works or not.

Thanks
yuvaraj.