[Solved] Find value of formula

Discuss the spreadsheet application
Post Reply
THEBookMan
Posts: 107
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

[Solved] Find value of formula

Post by THEBookMan »

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
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Find value of formula

Post by FJCC »

In the Find and Replace dialog, click More Options and set the Search In box to Values instead of Formulas
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
THEBookMan
Posts: 107
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: Find value of formula {SOLVED}

Post by THEBookMan »

Such a simple fix!
Thank you
⌡im
Open Office 4.1.3 Win 10
Post Reply