Assigning points to multiple people in one row

andrewb90

Well-known Member
Joined
Dec 16, 2009
Messages
1,075
I have a employee picnic and sports contest coming up and I am trying to figure out a scoring system to not only track a winner, but keep track of who was partnered with whom in which event.

I have a list of events/descriptions in column B. in each row there is a new event activity, juggling, 3 legged race, volleyball, etc... in column C&D I would want to put the two names of the people that were on the team, and E&F, G&H, etc. In my scoring sheet for individuals I would want to have a person's activities they participated in on their sheet as well as who they did the activity with.

So lets say Joey and Sara (not my real employees names) were in the three legged race. On my first sheet in the row for the race I would have Joey and Sara in the next two cells and beneath it would be the score they earned. (Column B4 would be merged with B5 and C4&D4 would say Joey and Sara respectively and C5&D5 would be merged to enter their score, Cells E&F and G&H would be the same as well.) Now on another sheet I would have participation results for 7 or 8 people and one of those people would be Joey. It would show what events Joey participated in and who his partner was, and how many points he had achieved.

I am thinking it would be easier just to type in the name of the people who participated in the event instead of finding each page and typing in the event and the person they completed it with.

I hope I made sense to somebody.

- Andrew
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,122,979
Messages
5,599,156
Members
414,294
Latest member
shariflotfi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top