those interested in FORM might find this file helpful

What it does:
it converts [20356] in one cell into [6] [5] [3] [0] [2] individual cells -- some might find this handy -- i don't know if this is the best or only way to achieve this -- it is just what i did

take care and good luck!

Attached Files

FORM.xlsx (10.6 KB, 631 views)

__________________
never smile at a crocodile -- don't be taken in by his welcome grin

Thats pretty handy got anymore tricks up your sleeve?

Very neat.
I didn't realise that you could combine LEFT and RIGHT in that way so I've learned something.
Thanks

thx for feedback -- appreciated

FORM Analysis v2.0 attached

the results from tonights Moonee Valley meeting are shown -- the BM Price displayed is a "Bench Mark" price based on rank!

enjoy

Attached Files

Moonee Valley FORM analysis v2.0.xlsx (185.1 KB, 596 views)

__________________
never smile at a crocodile -- don't be taken in by his welcome grin