- 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
Need an Excel Expert
Posted on 8/14/18 at 9:03 am
Posted on 8/14/18 at 9:03 am
I'm dealing with a spreadsheet with about 50k lines and need to pull out just particular information.
I've pulled out the particular column I need information from and performed Text to Columns based on commas...this works for what I need. After doing this to all 50k lines, I have varying lengths of rows...some go to DW, some to EC, some to ZZ, etc.
Within each of these rows, I only want to pull out cells that contain particular data and scrap the rest. For instance, below I just want to pull out cells that contain the word RAT:
monkey.>fly elephant.>restaurant fly.>missions rat./michael hangers.rat michigan?dog
I know I'm probably explaining this horribly, but if I'm making any sense, a lil help would be appreciated.
I've pulled out the particular column I need information from and performed Text to Columns based on commas...this works for what I need. After doing this to all 50k lines, I have varying lengths of rows...some go to DW, some to EC, some to ZZ, etc.
Within each of these rows, I only want to pull out cells that contain particular data and scrap the rest. For instance, below I just want to pull out cells that contain the word RAT:
monkey.>fly elephant.>restaurant fly.>missions rat./michael hangers.rat michigan?dog
I know I'm probably explaining this horribly, but if I'm making any sense, a lil help would be appreciated.
6
Posted on 8/14/18 at 9:04 am to mmmmmbeeer
Would it make sense to reorganize the information and do a v lookup?
Posted on 8/14/18 at 9:05 am to mmmmmbeeer
quote:
monkey.>fly elephant.>restaurant fly.>missions rat./michael hangers.rat michigan?dog
Posted on 8/14/18 at 9:06 am to mmmmmbeeer
quote:
Need an Excel Expert
I'll see if I can help.
quote:
I'm dealing with a spreadsheet with about 50k lines
They're called rows.
For real though. Look up "IF THEN" statements and tailor it to your desired outcome.
Posted on 8/14/18 at 9:07 am to mmmmmbeeer
I think I understand what you're asking. The easiest way:
Select All
CTRL+F and enter RAT
Click "Find All"
Select the first one
Scroll to the bottom, hold SHIFT, and click the last one with "RAT"
Close the window
CTRL - will delete the cells with "RAT"
Pick ENTIRE ROW
Select All
CTRL+F and enter RAT
Click "Find All"
Select the first one
Scroll to the bottom, hold SHIFT, and click the last one with "RAT"
Close the window
CTRL - will delete the cells with "RAT"
Pick ENTIRE ROW
This post was edited on 8/14/18 at 9:08 am
Posted on 8/14/18 at 9:14 am to Marciano1
quote:
I think I understand what you're asking. The easiest way:
Select All
CTRL+F and enter RAT
Click "Find All"
Select the first one
Scroll to the bottom, hold SHIFT, and click the last one with "RAT"
Close the window
CTRL - will delete the cells with "RAT"
Pick ENTIRE ROW
Man, I think this will work. Going to give it a shot.
Thanks!
Posted on 8/14/18 at 9:32 am to mmmmmbeeer
quote:
Need an Excel Expert
Damn, can't help you there. But will an Incel expert work?
Posted on 8/14/18 at 9:33 am to mmmmmbeeer
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News