- 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 7:07 am to yankeeundercover
Posted on 1/22/16 at 7:07 am to yankeeundercover
Do you know how to use sql? Much easier for this
1
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.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News