Find Command

[Mike H.]

If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that
contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find
1500? And if the cell contains 1500 but is formatted as 1,500, how do I
still find the 1500? Thanks.

 

[Paul C]

In the Find dialog box then is a button for Options>> (these are not shown by
default)

Clicking on the Options button will expand the box to show the advanced
options.

One of these is Look in. By default formulas is selected. Change this to
Values and you will be able to find your formula resulting in a value 1500.

 

[Pete_UK]

First of all, select all the cells in the range you want to search
(eg. select columns A to F). Then press F5 (GoTo) and click on Special
and then on Constants - the cells containing formulae will not now be
selected.

Then you can do CTRL-F to look for the number 1500 in those
highlighted cells.

Hope this helps.

Pete

 

[Mike H.]

How do you "format without the 1000 (,) separator"? I don't understand that
statement. I can't find an obvious number and I think it is because of the
comma. Please explain. Thanks.

 

[Mike H.]

Or suppose I wish to find the cells that contain a formula that results in
1500 but I don't know if it has a comma or not. Or I don't know if it is
1500 or -1500. Can I still find all these:
1500
1,500
-1500
-1,500
and cells that have formulas that result in all 4 of the above. I can't
seem to get it to work. Thanks.

 

[Mike H.]

I cannot get find to find the resultant value of a formula. I must be
missing something and nobody answered my question about what do you do if you
don't know the format of the cell or don't care (more likely). I could care
less about the format. I just want to locate number whether it is the result
of a formula or it is just a number, whether or not it has commas or not and
I could care less about the format of the cell. Is there not a way to do
this in 1 step?