- 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/22/16 at 9:58 am to TU Rob
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