We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
21 Mar 10
08:50
Joined:
Date Joined:
25 Jun 08
I've got a colum with 5 possible entries:
0,0.5,1,-0.5,-1
How do I count the number of instances of each one in separate cells please?
0,0.5,1,-0.5,-1
How do I count the number of instances of each one in separate cells please?
Show More
Raceform data downloaded into excel and all data in one cell.
Used to do it with wizard and use ' delimiter but that doesn't seem to work
Tried splitting the cells with "Text to Columns" but cells still overlap with various data.
Any suggestions
Used to do it with wizard and use ' delimiter but that doesn't seem to work
Tried splitting the cells with "Text to Columns" but cells still overlap with various data.
Any suggestions
I managed to sort some stuff recently using FIND,LEN and LEFT. It was messy and I'm not sure I could even do it again without a lot of thought, but googling those three might help.
Google show all text to the left of a symbol in excel and things along those lines might help
Google show all text to the left of a symbol in excel and things along those lines might help
Pinza, not sure if it applies in your case if you're using Interactive, but i know RP data downloads into one cell when using Internet Explorer, and into separate cells with Firefox.
+ maybe just give them a call? the tech guy on interactive seems reasonably helpful
Get the wizard up
click on "other" and use key on the left next to shift
which will give you |
That has sorted out the data in all the cells
click on "other" and use key on the left next to shift
which will give you |
That has sorted out the data in all the cells
good stuff Pinza! no doubt will need that in the future
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539