Does anyone know how to turn this excel function into an sql statement?
The function looks at my address and route. If it is different than the one prior it increments column G by 1 if it is the same it keeps column G as the same number. Ive been trying to piece together for days now but no luck.
IF(D3=D2, IF(C3=C2, G2, G2+1),1)