- 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
re: I figured out how to frame my excel problem!
Posted on 1/21/16 at 11:25 pm to Spock's Eyebrow
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...
1
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
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News