Hi . separate the 4 or 6 last start placing in Colm B Row 3.as.5127 or 245127 and put each in another Colms,7 in colm C,-2 in-E,-1 in F,-5 in G.then if it has 6 placings .4 in H.and 2 in i. l could then use for horse career start,win 2^nd and 3^rd.Thanking you..M60

Attached Files

Formula Help4 Placings 1.xlsx (77.1 KB, 625 views)

Here 'tis

Attached Files

Copy of Formula Help4 Placings.xlsx (77.4 KB, 637 views)

Mate thank you very much for solving the 4 placings much appreciated...can l ask one more favour the horses career starts-wins-2nds-3rds....l thought l could use your formula for that but no luck...can you help with that ...again Thank you......M60

Attached Files

Copy of Formula Help4 Placings again.xlsx (77.8 KB, 621 views)

This will do it.

Attached Files

Career Placings.xlsx (9.4 KB, 643 views)

Surround Mate thank you for the two excel fixes...much appreciated...that career one is a real great help Thanks again...M60

Surround Mate.... having trouble making it work...l've Attach what l did..must be missing something...yeah l know between the ears... lots of greys...hope you can help again ....Thanks M60

Attached Files

Career Placings.xlsx (80.6 KB, 600 views)

Yes it's those dashes causing it I think. There will be a way to do it but I can't recall it at the moment.
The career figures I used were from The Virtual Formguide website and those formulae handle any number of starts & placings.
This will keep you going for a while until someone with more skills comes along.

Attached Files

Career Placings.xlsx.xlsx (81.3 KB, 591 views)

Well l'll just manual put in if over 10...aleast l've got a great start thanks to you...all best M60

This will do it all for you no matter how many placings.
A bit ugly but it works.
All the best.

Attached Files

PLacings Example.xlsm (10.9 KB, 604 views)

Surround...Well Mate thank you ...the last one l added a +10 for the last number...and it got anything over 10 real good..... but for some reason stuffed the 3rd number mainly number 2 took any other number but 2.........l'm redoing my spreadsheet in the next few days.and put your new one in...... if your interested to see could send it to you...but need your e-mail...anyway Thanks again...... M60