Forum home » Delegate support and help forum » Microsoft Excel Training and help » Number search
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Number search
Resolved · Urgent Priority · Version 2003
Reply Thu 23 Oct 2008, 13:15Delegate Andrew said...
Andrew has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Advanced course
Number search
I am trying to search for a number in a large account spreadsheet. However, the number i am looking for is the product of a formula, and therefore does not come up when I use 'ctrl F' to try and find it. How can i search for numbers that are the product of formulas?
For upcoming training course dates see: Pricing & availability
RE: Number search
Hi Andrew
Thank you for your question.
You can use the Find feature (Ctrl + F) to find a formula - could you do a search for the formula instead?
Amanda
Reply Thu 23 Oct 2008, 14:38Delegate Andrew said...
RE: Number search
Unfortunately not, because it is a large spreadsheet with many instances of the formula. It is the specific results of the formula that I would like to search for. Is there any way that can be done?
RE: Number search
Hi Andrew
Try the following:
Go into Find, then click the Options button. Next to Look in, select Values from the dropdown list, then click Find Next.
Amanda
|