Help with locating errors in cells

Hi all, can anyone help with a query to save me time with a job i have to do!

I have a spreadsheet that lists a customer Sequence number in column A and a customer Raffle Ticket number in column B. These numbers have been scanned by a machine camera during a production run.

The Raffle Ticket numbers always run 10 digits apart ie: 100010, 100020, 100030 and so on. But sometimes the camera mis-reads the number and produces an incorrect number.

I have to find these incorrect numbers and fix them before sending the file to my client for their data entry. I am doing a simple formula =IF(A3-A2 <> 10, "Error","") which works fine but some files are 50,000 + records so to scan through to find the ERROR cells takes ages. I cannot do a filter as I need to check the cells above, below and around the incorrect cell to identify what the correct number should be and correct it.

Is there a formula or command that can locate the cells with the ERROR in and list them in another sheet/area for me to print and then be able to go direct to each cell that i need to?

thanks

Personally I would use a formula like =A3=A2+10 and copy down. Then Paste Special / Values over that column. Then use find and replace to replace TRUE with nothing so all you have left are the FALSE values (or what were the Errors using your formula). That way you can use Ctrl+Down Arrow to skip down to the very next "Error" rather than scroll down.

Hopefully that makes sense.

Thanks - this worked OK. A lot quicker than how I was doing it

If the numbers are ALWAYS going to be 10 greater than the previous one, could you not simply update them all in one fells swoop?

Say cell B2 held the value 100010, in C2 you could just put =B2+10 and copy down. That way it would automatically update all errors.

Perhaps I'm missing something completely and your data isn't that simply laid out.

In theory yes - but sometimes the production run may crash or stops and/or a new set of Raffle Ticket numbers will be used (and also there is Human Error) so there are times when the number throws out the sequence. This will highlight an error but with the production reports we will know why this is.

thanks again

Ah well, was worth an ask.

Glad you have a workable method now.

BSB.