[Solved] Find value of formula

Discuss the spreadsheet application

[Solved] Find value of formula

Postby THEBookMan » Fri Mar 20, 2020 6:56 pm

I have a very simple formula to discover duplicates:

=IF(H722=H723;"-.X.-";"") in column G

After sorting column H, an "-.X.-" is displayed in column I wherever there is a duplicate in column H.

Simple, quick, elegant!

BUT ... when I search for "-.X.-", everyone of the cells with that formula is found.

Can I do a search for only those where the "-.X.-" is displayed?

TNX,
⌡im
Last edited by Hagar Delest on Thu Mar 26, 2020 8:05 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 83
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: Find value of formula

Postby FJCC » Fri Mar 20, 2020 7:30 pm

In the Find and Replace dialog, click More Options and set the Search In box to Values instead of Formulas
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7522
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Find value of formula {SOLVED}

Postby THEBookMan » Thu Mar 26, 2020 3:50 pm

Such a simple fix!
Thank you
⌡im
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 83
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 21 guests