Hi All can any one please help me on this.
i need first it has to check that how many times that id exists then based on id count it has to match name rows with similar nuber of times.
e.g. US127473334L id exits 3 times in columns A so then it sud go to column B and match 1st row company name...