working out total scores

innmentor

New Member
Joined
Jan 27, 2020
Messages
16
Office Version
  1. 365
Platform
  1. Windows
Hi not been here for quite some time but here goes.
Have a 4x 10 grid where numbers (representing participants ) in a competition are entered in position in each row representing an individual discipline. So column a-d represent
positions attained 1st -4th with points 10,8,6,2 for each position So grid is filled in with contest and 34 in a1 24 in b1 no one in c1 or d1 which means if no one entered then a blank is left. I need to create a colunm that gives me the unique numbers in the grid ignoring spaces left and attribute to each entrant the number of points each one has attained to then rank them. Any ideas how I can do it . I have been going round in circles trying to use rank function but I am totally lost- HELP PLEASE!
 

Attachments

  • excel score 1.jpg
    excel score 1.jpg
    72.6 KB · Views: 12
MAGIC!!!spot on fantastic Fuff works a treat and has saved my life , Wish I had met you a week ago as it would have saved me some grey hairs YOU MUST DREAM EXCEL CHEERS
KEN
this is what you helped save THANKS
 

Attachments

  • prod 2024.jpg
    prod 2024.jpg
    113.2 KB · Views: 2
Upvote 0

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You're welcome & thanks for the feedback.
 
Upvote 0
FLUFF! thanks a million the solution you gave worked a treat last week-end and everything went so smoothly and every calculation and final positions was spot on. Once again thanks for your time and patience spent on my behalf

Ken
 
Upvote 0

Forum statistics

Threads
1,224,878
Messages
6,181,527
Members
453,053
Latest member
DavidKele

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
Back
Top