Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting cells equals to a value
Hello everyone:
I wonder how can I select, without using vba, the cells within a range that are equal to 3 for example. Using "Go to special" can be selected empty cells, cells with errors ... but I would like to know if I can select cells that are equal to a certain value. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting cells equals to a value
Not without using VBA.
In article , "Mnilo" wrote: Hello everyone: I wonder how can I select, without using vba, the cells within a range that are equal to 3 for example. Using "Go to special" can be selected empty cells, cells with errors ... but I would like to know if I can select cells that are equal to a certain value. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting cells equals to a value
Select a range.
EditFind..............your choice of enabling or disabling "match entire cell contents" What: 3 Find All Gord Dibben MS Excel MVP On Sun, 16 Nov 2008 22:00:07 +0100, "Mnilo" wrote: Hello everyone: I wonder how can I select, without using vba, the cells within a range that are equal to 3 for example. Using "Go to special" can be selected empty cells, cells with errors ... but I would like to know if I can select cells that are equal to a certain value. Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting cells equals to a value
In article ,
JE McGimpsey wrote: Not without using VBA. Oops - forgot which group was posting in... MacXL can't do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
highlight cells equals sum, not count | Excel Discussion (Misc queries) | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) |