I have data in one column like this 1668X which is a horses last five runs and I want to put each run into 5 separate columns. What sort of formula would I need for this?

Thanks
Twodogs

Hard to explain, so here's an example based on what you gave:

Check out the formulae in each cell.

Attached Files

Twodogs.xls (15.0 KB, 725 views)

__________________
RaceCensus - powerful system testing software.
Now with over 409,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Thanks Chrome Prince

Now I have that I tried to countif a number and not X but I keep getting an error. Any ideas?

Twodogs

Twodogs


I posted a similar Excel query a while ago - Shaun provided an excellent example spreadsheet which had loads of useful formulas which helped me split up data in single cells etc.

Cheers

Thanks Sparky 12

Found it!!

http://forums.ozmium.com.au/showthread.php?t=15977

Twodogs

The mrexcel messagboard is also an excellent resource of information and help.

__________________
RaceCensus - powerful system testing software.
Now with over 409,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Just about all formula needed for extracting and processing form can be found in that sheet, i would like more automation involved but it allows for errors and adjustments.

You could post a small example of the sheet with say about 20 entries preferabely with the split already made so that I can see where you want it and where you are getting it from
Is the name of the sheet that you use always the same name?
Macros are much better especially because you dont need to copy and paste the formular. I generaly have a sheet that has my macro and I then point the macro to find the sheet with the info and proces it with just one click.

Michal