Finding values

**jasonGOSH** · 05-08-2013, 01:45 PM

Hi, I have a large amount of data and am trying to find certain values.

Firstly - I am looking for any cell which has the number 0 in it, as I need to edit that specific cell. However, when I search for the number 0, multiples of 10 (e.g. 10,20,30,etc) come up in my search.
Is there anyway to find the number 0, without also finding the multiples of 10?

Secondly - I am also looking for values over 100, is there a search function which allows me to do this?

Thank you

**oeldere** · 05-08-2013, 02:08 PM

with an filter.

But you will get better result if you add an excel file, without confidentional information.

Please also add the desired (expected) result.

**xwarlock10x** · 05-08-2013, 04:19 PM

=COUNTIF(A1:G14,0)

where A1:G14 IS WHERE YOUR DATA IS WITH THE 0 VALUES.. YOU CAN ALSO US A CONDTIONAL FORMATTING TO HIGHLIGHT THE 0 VALUES

**newdoverman** · 05-08-2013, 08:36 PM

If you are trying to select the cells that only have the value 0 in it and no other contents, click on Find, enter 0 in the Find What field. Select "Match Entire Cell Contents". Click on Find All. A window will open listing all the cells that only contain 0. To select all those cells, click on the first cell reference and hold down the shift key and click on the last cell reference. All the cells with only 0 as the contents will be selected on the worksheet. If you are only interested in some of the cells, hold down the Ctrl key and click on each cell reference in the window that is of interest to you.

For the second part of your problem use Conditional Formatting. Click on Conditional Formatting, Highlight Cells Rules, Select Greater Than, enter 100 click OK.

The same process can be used to format 0 value cells.