#i was able to identify the chunks of serials that were sequential at least using =IF(A3=A2+1‚“”‚“STOP”)
Explore tagged Tumblr posts
Text
had to transfer 500 serials today (each serial must be entered into its own individual field)
#i was able to identify the chunks of serials that were sequential at least using =IF(A3=A2+1‚“”‚“STOP”)#and then copy all but the last digit so i could paste that and then type just the last digit#could go fast this way but still tool a bit
17 notes
·
View notes