- 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:28 pm to jimbeam
Put these in a google sheets. Share them with each other. Run an import range to combine the two.
=countif(A1:A, “<>”) + countif(B1:B, “<>”)
That would equal the number of each list where the cells that are not blank are counted and then added together.
=countif(A1:A, “<>”) + countif(B1:B, “<>”)
That would equal the number of each list where the cells that are not blank are counted and then added together.
Posted on 2/25/21 at 8:37 pm to PeteRose
I interned at a O&G company, they gave you a computer with no mouse. Best way to learn.
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:26 pm to Swazla
It will for a few days at least until it’s set
Posted on 2/25/21 at 9:43 pm to Pedro
Have and index number for each name (sequential, and have it be blank if there's no name by it).
If you're going to have between 100 and 500 names or something like that, make 1 cell that has the following type of equation:
=max(Sheet!B5:B1005)+max(Sheet2!B5:B1005)
If you're going to have between 100 and 500 names or something like that, make 1 cell that has the following type of equation:
=max(Sheet!B5:B1005)+max(Sheet2!B5:B1005)
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/25/21 at 10:50 pm to Rendevoustavern
I saw this
And thought this
quote:
vlookup the entry on both sheets (T/F)?
sum/countif?
And thought this
quote:
1. vlookup the entry on both sheets
2. (T/F)
3.???
4.countif!
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.
Popular
Back to top
Follow TigerDroppings for LSU Football News