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?
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
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
