Hi,
Suppose i have data from A1 to A500 and i have following names:
Ajay 125
Shyam 76
Namdeo 215
Sunil 84
what i want is beside each cell like from B1 to B125 Ajay name to appear and then from B126 to B201 Shyam name should appear likewise i need till B500 all the names to appear.
This is simple data sometimes column A contains data 15000 to 20000 cells and names are more than 50 so need formula which can work.
Thanks in advance
Goodboy
Bookmarks