Sign in to join the conversation:
Hello team
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advanceoded
Great, thanks for letting us know! 🙂
I am looking for a Duplicate function to find matches between a Campaign ID column and the Status column.
Currently using:
=IF(COUNTIF([Campaign ID]@row:Status@row, [Campaign ID]) > 1, 1)
it returns as #UNPARSEABLE
Hi @Rhiannon Castro
You're missing the row number or ID after the column name for the criteria of what you're looking for in the COUNTIF function:
COUNTIF([Campaign ID]@row:Status@row, [Campaign ID])
Should be:
COUNTIF([Campaign ID]@row:Status@row, [Campaign ID@row])
Try this:
=IF(COUNTIF([Campaign ID]@row:Status@row, [Campaign ID]@row) > 1, 1)
Cheers,
Genevieve
Hello, I am having trouble with suggested formula. Any advice is appreciated:
Hello @duncbro
Is the above formula returning an Unparseable? I notice you have a semicolon instead of a comma in your formula, whereas all other term separators are commas. It also looks like you have an extra parenthesis on the very end - notice it is black. The last parenthesis will be blue when you have the correct number of parentheses in your formula (this doesn't mean they are necessarily in the right place).
Does correcting those two syntax errors solve your problem?
Kelly
Yes it did, thank you. However, it did not return any values and I am sure the column contains duplicate values.
try this
=IF(COUNTIFS([SC#]:[SC#], <>"")>1,1)
sorry, I didn't pay attention to your @row criteria. You want it to look at all the cells so this is really reading @cell<>"" (No blank cells).
Thank you. The recommended formula highlighted all cells.
Sorry, @duncbro. The original formula formula with the @row should have worked- it was a brain blip on my part.
To be clear, this formula returns a zero
=IF(COUNTIFS([SC#]:[SC#], [SC#]@row)>1,1)
You should see a pink parenthesis for the CountIfs, and blue one enclosing the IF statement.
Thank you Kristy! That "=" is the game changer!
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
