• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find Column number of error in sheet

B

brianmock

Member
I have a sheet of calculations that is 350 columns wide and 300 rows high

I have checked for errors using
=SUMPRODUCT(--(iserror(offset(Data!$A$1,0,0,300, 350))))

this tells me if there are any errors- which is good.
I then have to search for them in the large sheet- which is bad

Is there a way to find the column (and/or row) number of the error?
 
I guess you can conditional format the sheet to highlight error that will be easier to catch!!
 
Goto Conditional Formatting>Formula> and use:

Code: 
=ISERROR(A1)=TRUE

and format to fill color, apply to entire data. Hope that works,
 
Hi Brian ,

If it is really formula errors that you want to look at , can you not use the GoTo facility and click Special -> Formulas -> Errors ?

Pressing the TAB key takes you to each error cell one by one.

Narayan
 
What I am trying to find is a diagnostics tool (I have multiple tabs of 350 x 320 cells) to prevent errors in.
The above formula counts errors.... then I have to search the entire sheet to find them.
 
You must log in or register to reply here.
Back
Top