- 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: Excel question for you geniuses
Posted on 4/26/24 at 2:59 pm to FortunateSon
Posted on 4/26/24 at 2:59 pm to FortunateSon
quote:
Ask ChatGPT to explain it to you - seriously. It involves using a formula called VLOOKUP that looks up data in a column. You can highlight a cell if it is repeated or missing out of a list. But VLOOKUP is the easiest method, IMO.
This 100%. Depending on what dataset you have, I also have had success with INDEX and MATCH. Thanks to ChatGPT. If you tell it your column numbers and worksheet tab names. it will completely write the formula for you. Copy and paste. Done.
Back to top
Follow TigerDroppings for LSU Football News