how to use find function to locate error cells?

[perfection]

I have a worksheet that has in times and out times. have created a column to find the difference between out and in with a forumla. However due to sometimes incorrect data entry the out time is lower than the in time giving me a negative timne value displayed by a series of # signs. I now wish to go sequentially down this column that has more than 12,000 entries locating each ########### and correcting the timings. How can i jump from one ######### cell to the immediate next one and so on till the end of the column?

Could not find a way to do it with the find function

[NBVC]

Try using AutoFilter from the Data|Filter menu.

Then Filter for the #######

Then you can down-arrow you way through the rows...

Then go back to Data|Filter|AutoFilter to unfilter.