I am trying to write a script that uses the remove duplicates command on rows "O" and "P". However, I want it to clear the duplicate's cell contents as opposed to removing rows when a duplicate is found. Could I do this with a countif > 1 statement? Not really sure how to tackle this one.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Remove duplicates, but clear them instead
- Thread starter interner
- Start date
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Similar threads
- Replies
- 4
- Views
- 348
- Replies
- 3
- Views
- 323
- Replies
- 6
- Views
- 484
- Solved
- Replies
- 12
- Views
- 767
