PDA

View Full Version : Broken cells



dataztrul
10th November 2016, 09:41 PM
Hello!
During some point a couple of months ago I must have done something that messed a couple of cells. I have tried to copy my data over to a whole new sheet but the broken cells seems to come with. There is around 5000 bets in the sheet so it is hard to know exactly at what point this happened. Is there anyway I can copy over the data to a new sheet without the broken cells following?

Cheers

dataztrul
10th November 2016, 10:20 PM
As you can see on the image at this link: https://www.dropbox.com/s/8yiqur44ayty0zg/Bild%20sheet.png?dl=0

Wagers in column K and M does not correspond. There is bets of 40k missing. Mostly losses!

admin
11th November 2016, 12:49 PM
Hi dataztrul, there is a chance that M12 and K24 don't equal one another due to some misspelt names in the Bookmaker column of the Bets worksheet.

This once happened to me too. What I did was copy all of the data from the Bookmaker column (B) of the Bets table into a blank spreadsheet using Paste -> Values. I then sorted the column in the new spreadsheet alphabetically and was able to find the odd misspelt bookmaker. I then went back to the Bets worksheet and pressed Ctrl+H to use the Find and Replace feature. I then replaced all instances of misspelt names with the correct ones and the two values in the Performance Summary then equalled each other.

Have a go trying that and send me a PM if you're still experiencing issues.

dataztrul
11th November 2016, 06:22 PM
Wow, that actually worked it out. Thanks a lot!