I hate to bother GQ with this type of work question but I don’t even know what sort of search terms I would enter into Google, MS Help, Etc.
What I have is an incomplete list of job numbers my company has done. I want to find out which jobs aren’t in the database. here is an example:
7502
7503
7557
7559
7560
etc.
So I’d like is to have excel return the numbers 7504-7556, 7558, and so on.
My excel knowledge is kinda patchy, but I can do basic IF THEN sorts of formulas. I just don’t know what sorts of commands are available for this sort of task, or what sort of method I might use. There might even be something obvious that I’ve missed.
I thought I could go to the bottom of the column, generate a complete list of job numbers (10 000 of them), sort , and kludge together something to eliminate the doubled up numbers. But surely there would be a more elegant solution than this?
BTW, I won’t be able to reply for a while, as I’m going home now. Dopers, you have until tomorrow!
Thanks
Jaguars!