Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for TRUE in spreadsheet
Is there a way to search for, and warp to, a cell that evaluates to
TRUE? or FALSE? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for TRUE in spreadsheet
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 On Sep 4, 11:38*pm, Paul wrote: Is there a way to search for, and warp to, a cell that evaluates to TRUE? *or FALSE? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for TRUE in spreadsheet
Thanks, Pete.
On Sep 4, 7:30*pm, Pete_UK wrote: 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. On Sep 4, 11:38*pm, Paul wrote: Is there a way to search for, and warp to, a cell that evaluates to TRUE? *or FALSE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Spreadsheet for a name | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |