OK Larbec,
I had an epiphany in the middle of the night! Your string of 5 8's is actually 0,8,8,8,8,8,0 which would be counted in the spreadsheet as 0,1,2,3,4,5,0. So I could probably write some sort of IF statement that would only put a digit in coloumn H IF >1 AND the next digit is 0, yes?
Trouble is I am just starting a helluva week with travel to Memphis, Houston, Louisville and Detroit. I probably won't have time to look at this again until next weekend, so feel free to follow up on this option by yourself in my absence.
If anyone reading this has Excel skills, I would appreciate it if you could help Larbec out in my absence.
Good luck!
I had an epiphany in the middle of the night! Your string of 5 8's is actually 0,8,8,8,8,8,0 which would be counted in the spreadsheet as 0,1,2,3,4,5,0. So I could probably write some sort of IF statement that would only put a digit in coloumn H IF >1 AND the next digit is 0, yes?
Trouble is I am just starting a helluva week with travel to Memphis, Houston, Louisville and Detroit. I probably won't have time to look at this again until next weekend, so feel free to follow up on this option by yourself in my absence.
If anyone reading this has Excel skills, I would appreciate it if you could help Larbec out in my absence.
Good luck!