Excel newbie - managed to use other's codes and modify to use last value in a column (column C), increment it by 1 and start a new column with this value.
However, I need to reset the count from 1 if this number is above 10, but I can't figure out how to combine (I think?) an IF statement to do this!
Eg: If value from the last cell in the previous column>10 then start the count in the next column, from 1
any help much appreciated!