Hi there trying to figure out some code so i can find out the missing number in a range of specific numbers.
eg. I Have -
"A2" - 101
"A3" - 101
"A4" - 102
"A5" - 102
"A6" - 104
"A7" - 104
"A8" - 105
"A9" - 105
And i want x = 103
and y to return the 6th row number y = 6
I dont know maybe step through a loop missing out every second number of the range A2 :A9 but i just cant come up with anything to get the missing number. Cheers
Bookmarks