Excel help please

dont know if this is what you need but...

copy what you need then paste in excell as text on one single cell

Thanks .. i dont think that would be it

To clarify better ..
In a 6 runner race how to sort columns for Timeform 1-2-3, or ATR Speed ratings which only list the top 3.

A B C
Bob Tisdall Desert Orchid 1
Docklands Express Pegwell Bay 2
Desert Orchid Yahoo 3
Nortons Coin
Pegwell Bay
Yahoo

Obviously I cant sort alpahabetically or by racecard number which I could where there is a rating for each horse in the race

I really really hope this comes out proprerly when I press Post

Nopes : but i hope its understood.. thanks again in advance

sorry but i know nothing about horses so no idea what you talking about

maybe this link helps you... or not

http://www.youtube.com/user/ExcelIsFun#p/c/D8EEA7196D943ED5

he is the best teacher of excel on youtube (but this new way of youtube presenting personal channels is sh!t,i cant find the search function, and this channel has hundreds of videos)

thanks, i'll check out the site

its not really a horse racing query, its an excel sort query and i'm sure someone on the forum knows how to do it!

Specifically it is a MATCH function query

The answer is =match(a1,$b$1:$b$6,0)...then do some copy and paste to sort out the non-matches

Thanks starfish, you're an absolute star(fish)

Perhaps Find function or Search function might be better. Less likely to find the nearest number if the sought for number is not available.

Good work, starfish, lad

;)