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
Could you attach a sample workbook and show us your starting data along with your expected result?
BSB
Is it possible to have the name in column A and the number of replicates needed in column B? Results would then be in col. C. It would be MUCH MUCH easier.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
...or if name and number are already in one cell, are we allowed to separate them into two helper cols (B &C) with results in D?
Like this...
Last edited by Glenn Kennedy; 10-14-2018 at 03:31 AM.
I have just noticed that your profile states Excel 2003. If that is true, you may need this, instead:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks