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
[Solved] Find value of formula
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
[Solved] Find value of formula
Last edited by Hagar Delest on Thu Mar 26, 2020 8:05 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Open Office 4.1.3 Win 10
Re: Find value of formula
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area