working out total scores

[innmentor]

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!

 

[innmentor]

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

 

[Fluff]

You're welcome & thanks for the feedback.

 

[innmentor]

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