This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
