Find Command
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
On Mar 24, 6:42*pm, Mike H. wrote:
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.
|