The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello,
I’m trying to write a formula to detect if there is a duplicate record, ignoring a few columns.
I’m not very good with formulas, but I imagine it’d be two if statements, which if correct I’d like it to highlight the row red? There’s probably a...
Hey Adam,
Here is a screenshot of an example database. In this example there are two duplicate entries for Kate Bush (ignoring the PC NO and Paid columns). I’m trying to come up with a formula that would detect this duplication and highlight it red.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.