- 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
Excel formula question
Posted on 2/25/21 at 8:20 pm
Posted on 2/25/21 at 8:20 pm
I’m trying to come up with an invite list for an event and there’s 2 sheets between the 2 people involved. I want to keep a running total of the people on the list between the 2 sheets. What’s the best way to go about this?
Posted on 2/25/21 at 8:22 pm to Pedro
vlookup the entry on both sheets (T/F)?
sum/countif?
Are you trying to count people on the list or see if they are on both lists?
sum/countif?
Are you trying to count people on the list or see if they are on both lists?
This post was edited on 2/25/21 at 8:23 pm
Posted on 2/25/21 at 8:24 pm to Pedro
Can you not just combine the lists into one sheet then dedupe?
Maybe I'm confused about what you're doing
Maybe I'm confused about what you're doing
Posted on 2/25/21 at 8:25 pm to Pedro
If you want one list you could copy one on the end of the other and then remove duplicates.
Names are crap to work with, one letter off and they don't match
Names are crap to work with, one letter off and they don't match
Posted on 2/25/21 at 8:27 pm to Pedro
Not to get off topic, but I once worked with this Korean girl and she did excel all by keyboard. Good lord she was fast. It was just amazing to see her work.
Posted on 2/25/21 at 8:39 pm to Pedro
No one gives 2 sheets about your problems
Posted on 2/25/21 at 8:46 pm to Pedro
If you’re trying to get one list without duplicates, just combine them and use the remove duplicates tool as others have mentioned. Then sort alphabetically to find the remaining misspelled names that are still duplicated.
If you’re trying to find only names that are on BOTH lists, you could use either INDEX & MATCH or VLOOKUP.
If you’re trying to find only names that are on BOTH lists, you could use either INDEX & MATCH or VLOOKUP.
Posted on 2/25/21 at 8:51 pm to Pedro
Highlight the column and hit sum. Do the same on the next sheet. Then add the numbers together
Posted on 2/25/21 at 8:54 pm to Pedro
quote:
I want to keep a running total of the people on the list
So the list keeps changing?
Posted on 2/25/21 at 9:45 pm to Pedro
quote:Have the two people get together to remove duplicates before sending it to you. Jeesh
2 sheets between the 2 people involved.
Posted on 2/25/21 at 10:28 pm to Pedro
What grade did you receive in ISDS 1100?
Posted on 2/26/21 at 12:02 am to Pedro
Google for a macro to use.
Or combine & de-dupe.
Or combine & de-dupe.
Posted on 2/26/21 at 12:32 am to Pedro
Set it up in google sheets in a shared file with rsvp boxes so everyone can check off for themselves and see who all is invited so you can avoid the awkward who all is coming conversation
Popular
Back to top
Follow TigerDroppings for LSU Football News