General Betting
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?
sort by:
Show
per page
Replies: 11
|
By:
google =countif
|
|
By:
will do ta
|
|
By:
sorted, cheers
|
|
By:
not a problem
|
|
By:
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 |
|
By:
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 |
|
By:
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.
|
|
By:
+ maybe just give them a call? the tech guy on interactive seems reasonably helpful
|
|
By:
Thanks guys.
|
|
By:
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 |
|
By:
good stuff Pinza! no doubt will need that in the future
|