Search for TRUE in spreadsheet

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Is there a way to search for, and warp to, a cell that evaluates to
TRUE? or FALSE?
 
Highlight a range of cells (or the whole sheet), then press F5 (GoTo).
Click on the Special button and then select Formulas, and de-select
Numbers etc to just leave Logicals. Then click OK.

Hope this helps.

Pete
 
Thanks, Pete.

Highlight a range of cells (or the whole sheet), then press F5 (GoTo).
Click on the Special button and then select Formulas, and de-select
Numbers etc to just leave Logicals. Then click OK.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to run in event of cell value <>"" 3
Auto Cell Height Adjustment for text entered 3
Excel - 2003 - Delete data if conditions met 8
Automatically fill in TRUE values 2
If statement for a range of cells 3
searching for cells that "contain" certain value 3
Excel JUMP FROM SEARCH BAR TO RESULT 3
Lookup formula needed 1

Back
Top