P
peterfc2
Hi
I have a text file of football results.
i.e.
utd|3|rovers|3
city|2|town|2
etc.
Delimited into Columns
This file is imported in excel.
Now i want to create a results grid from that data
utd rovers city town etc AWAY
utd X 2-2 3-3
rovers 1-2
city 2-3
town
etc
HOME....
Where the results are 3-3 2-2 etc.. I need (here it comes) a formula.(
I hope)
that uses the data in the imported text file
I think this should be possible but I can't get it right.
I'm sure someone with more experience than myself may
find a solution.
Cheers
Peter
I have a text file of football results.
i.e.
utd|3|rovers|3
city|2|town|2
etc.
Delimited into Columns
This file is imported in excel.
Now i want to create a results grid from that data
utd rovers city town etc AWAY
utd X 2-2 3-3
rovers 1-2
city 2-3
town
etc
HOME....
Where the results are 3-3 2-2 etc.. I need (here it comes) a formula.(
I hope)
that uses the data in the imported text file
I think this should be possible but I can't get it right.
I'm sure someone with more experience than myself may
find a solution.
Cheers
Peter