+ Reply to Thread
Results 1 to 5 of 5

Name beside the cell

  1. #1
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    122

    Name beside the cell

    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

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Name beside the cell

    Could you attach a sample workbook and show us your starting data along with your expected result?

    BSB

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Name beside the cell

    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



  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Name beside the cell

    ...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...
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 10-14-2018 at 03:31 AM.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Name beside the cell

    I have just noticed that your profile states Excel 2003. If that is true, you may need this, instead:
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?
    By spookymyo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2021, 02:12 PM
  2. [SOLVED] cell a function doing math on previous sheet, cell b - cell c result in cell d...
    By dad812 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-08-2018, 08:20 AM
  3. Replies: 6
    Last Post: 01-23-2018, 04:49 AM
  4. If Cell A is equal to Cell B replace the data from Cell A with Cell C. How can I do this.
    By tristanhathaway in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2014, 08:05 PM
  5. [SOLVED] How to create/run "cell A equals Cell B put Cell C info in Cell D
    By abmb161 in forum Excel General
    Replies: 7
    Last Post: 02-05-2014, 02:20 AM
  6. Replies: 1
    Last Post: 11-06-2013, 02:56 AM
  7. Replies: 1
    Last Post: 11-03-2012, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1