excel help.JPG
The final result should be
Bringing the Most: Bob
Number of Items: 6
Thanks for the help!
excel help.JPG
The final result should be
Bringing the Most: Bob
Number of Items: 6
Thanks for the help!
If you post a workbook with some sample data and the results you expect it will be much easier to help you.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Example File.xlsx
Here is the example file that I posted. Thanks!
Select and copy all the names and paste into a column and use Data Tab, Remove Duplicates to form a list of names without duplicates. I used H3:H7 for the final list of names. I I3 enter this formula and fill down to give the count of times each name appears in the data.
Formula:Please Login or Register to view this content.
In D13 where you want the answer to Bringing the most enter this formula
Formula:Please Login or Register to view this content.
For the number of items enter this formula in D14
Formula:Please Login or Register to view this content.
B C D E F G H I 3 BBQ Birthday PartyJoe 2 4Items Name Items Name Bob 6 5Ketchup Joe Cake Dave Sue 2 6Hot Dogs Bob Hats Don Dave 2 7Hot Dog Buns Bob Glitter Dave Don 1 8Soda Sue Candles Bob 9Forks Bob Soda Bob 10Salad Bob Ketchup Joe 11Cake Sue 12 13Bringing the Most Bob 14Number of Items 6
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Two options here. One of them looks like this:
Formula:Please Login or Register to view this content.
I like your solution doverman, but the data set that I'm dealing with changes quite frequently and is also quite large. For example, Bob calls me up and says he can no longer come to the either event. Other people take over for him, and a new person (Anne) is added. Also now both Sue and Joe are both bringing 4 items. Ideally, I'd like Bob to automatically be removed and Anne to automatically be added. Thus the copy and paste method would no longer work.
excel help2.JPG
Example File2.xlsx
Is there a way to always copy data from one column and paste it into another column? My number of Items will never change.
I think you're on to something Jacc. However, I need know who is bringing the most items to both events. In this file it is clearly Sue and Joe. That's kind of why I asked doverman about copy columns into one big column so that you could perform the formulas in C14/C15 and E12/E13 just for both events.
excel help3.JPG
Example File, Jacc_changed.xlsx
Last edited by bkpaguy; 10-16-2015 at 11:04 AM.
I made a massive change to the way that your data is entered. I made a table out of both ranges and then created a Pivot table based on that table. Now when you add names to the list the Pivot table can be updated by right clicking in the pivot table and clicking on refresh. This will give you a listing of the names in alpha order and the number of items for each name. Beside the pivot table, I have extracted the max number of items brought by an individual and beside that the list of names who may have brought that same amount.
Awesome doverman! I've never worked with a pivot table before so that is new to me, but I believe this will work for my application. How could I forget that Alex was bringing the beer! Thanks a million!
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks