Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel Ctrl-F (find) problem. How to find results of a function?

PrzemoF · 2017-01-16 15:49:33

How can I search for result of a function? cell A1 = 1 cell B1 = 1 cell C1 = A1 + B1 (that gives 2) When I search for "2" excel doesn't find anything. Any ideas how to work around that? Solved: Look in: Values

16-01-2017 03:49PM

#1

PrzemoF

Registered Users, Registered Users 2 Posts: 1,929 ✭✭✭

Join Date: May 2010

Posts: 1791

How can I search for result of a function?

cell A1 = 1
cell B1 = 1
cell C1 = A1 + B1 (that gives 2)

When I search for "2" excel doesn't find anything. Any ideas how to work around that?

Solved: Look in: Values

0

Comments

#2 16-01-2017 03:54PM

StupidLikeAFox

Registered Users, Registered Users 2 Posts: 7,886 ✭✭✭

Join Date: August 2004

Posts: 7654

When you press Ctrl+F click the "Options" button. The third dropdown there is "Look in:" - change this from Formulas to Values

0