Match another two rows based on count of ID duplication/COUNT in another columns

[aayaanmayank]

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 with next two rows/ hope it makes sense.

ID Name
US127473334L ASPHUDSONELECTRICSALESCORP
US127473334L ASPHUDSONELECTRICSALESCORP
US131491494L ASPAGIINDUSAINTR
US131491494L ASPAGIINDUSAINTR
US133929949L ASPJONESLANGLASAC
US133929949L ASPJONESLANGLASAINC
US134399399L ASPCENTRALMONTANAMEDICALINC
US134399399L ASPCENTRALMONTANAMEDICAL

i made a macro but that is working on on compan names row by row.

'FOR Company
Range("F2").Select
ActiveCell.Interior.Color = vbYellow

For U = 2 To LASTROW1

Set MYNAME2 = Cells(U, "f")
Set MYNAME3 = Cells((U + 1), ("f"))

If MYNAME2.Value = MYNAME3 Then

SHGROUP.Cells(U, "f").Interior.Color = vbGreen
SHGROUP.Cells(U + 1, "f").Interior.Color = vbGreen
ActiveCell.Offset(1, 0).Select
Else:

ActiveCell.Offset(1, 0).Select
SHGROUP.Cells(U + 1, "f").Interior.Color = vbYellow

End If
Next U

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-based-their-id-another-cell.html#post5109692

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).