I have sheet1 wherein, Column A and B is filled with data- In Column B i have numbers which is like 201,201,450,1001,2540,5456,...etc and it goes till 500 Rows.
Now i want at Column C to automatically assign the name of a person equally in number as Mr. A as 3000 Mr B 3000, Mr C 3000 and so on...