Check box for duplicate rows
Hi,
I'm looking for some help with a formula. I have rows of request numbers, some are duplicates, and I'd like to have a box automatically check for the duplicates. The plan is to keep one of the rows then set an automation to move the row with the checkbox to an archive sheet, probably have than one set to run on a time basis like hourly. That way the sheet would only have one of the duplicate rows for an accurate count.
I have a column with all of the request numbers and I created a secondary column that is auto numbered (I saw this in a similar help thread) and I get #unparseable no matter how I tweak it.
The current formula I'm trying is:
IF(COUNTIFS(Request:Request; Request@row; ID:ID; >ID@row) > 0; 1; 0)
What I want to end up with is a sheet that contains all of our closed requests with none of the duplicates without having to export it to excel to clean it up.
Any help would be much appreciated!
Thank you
Best Answer
-
@Steven Deem You need to replace your Semi-colons with commas.
Answers
-
@Steven Deem You need to replace your Semi-colons with commas.
-
@JamesB Thank you. I really appreciate the help. Sometimes I forget the small stuff staring at formulas all day
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!