- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
I figured out how to frame my excel problem!
Posted on 1/21/16 at 10:50 pm
Posted on 1/21/16 at 10:50 pm
I have column B which has names of employees and column A has employee ID. How do I add the name in column B if column A contains same exact employee ID more than once?
eta: obviously column B isn't completely filled out with names
eta: obviously column B isn't completely filled out with names
This post was edited on 1/21/16 at 10:53 pm
Posted on 1/21/16 at 11:11 pm to yankeeundercover
Add the name to what?
In any case, see if COUNTIF will help you.
In any case, see if COUNTIF will help you.
Posted on 1/21/16 at 11:25 pm to Spock's Eyebrow
Basically, Col.B doesn't have all the employee names and there's 12,000 lines.
All of the employee ID's are there in Col.A... so I want to scrub the Col.A for an associated "partner" in Col.B...
I need to populate Col.B if the number matches from Col.A...
If Col.A has a Name Match in Col.B (save that for later), then, if Col.B is BLANK and Col.A matches another Col.B (that isn't BLANK) then replace BLANK with the Employee Name...
All of the employee ID's are there in Col.A... so I want to scrub the Col.A for an associated "partner" in Col.B...
I need to populate Col.B if the number matches from Col.A...
If Col.A has a Name Match in Col.B (save that for later), then, if Col.B is BLANK and Col.A matches another Col.B (that isn't BLANK) then replace BLANK with the Employee Name...
Posted on 1/21/16 at 11:44 pm to yankeeundercover
The closest thing I could come up with is:
IF A has EMPLOYEE ID and NAME is present in B (anywhere), then replace "BLANK" with NAME
IF A has EMPLOYEE ID and NAME is present in B (anywhere), then replace "BLANK" with NAME
Posted on 1/22/16 at 5:31 am to yankeeundercover
Okay, you want to go from this:
And have it automatically do this:
Is that what you want it to do?
And have it automatically do this:
Is that what you want it to do?
Posted on 1/22/16 at 7:07 am to yankeeundercover
Do you know how to use sql? Much easier for this
Posted on 1/22/16 at 8:58 am to jeff5891
Copy the columns into another sheet in the workbook. Sort by the Names so that the blanks are at the bottom. Delete those rows. In the original sheet, use a Vlookup function. =vlookup,A1,then highlight the cells on the other tab, and press F4,2,false) Drag this formula down all of column B and it will return the values for every cell. Then you can copy/paste special values.
Posted on 1/22/16 at 9:58 am to TU Rob
quote:
Copy the columns into another sheet in the workbook. Sort by the Names so that the blanks are at the bottom. Delete those rows. In the original sheet, use a Vlookup function. =vlookup,A1,then highlight the cells on the other tab, and press F4,2,false) Drag this formula down all of column B and it will return the values for every cell. Then you can copy/paste special values.
This is how I would start. Only change would be to convert the lookup tab into a table so that you can add employees to the table without having to update the vlookup range.
Posted on 1/22/16 at 3:18 pm to CubsFanBudMan
Write a macro to do this, it would be easier than a formula.
Popular
Back to top
Follow TigerDroppings for LSU Football News