• Home
  • Blog
  • Projects
    • QWcrm
    • Joomla
      • mod_helloworld
      • plg_helloworld
      • QWRealURL
  • KB
    • Articles
    • Links
  • Forum
  • Stuff
    • Links
  • Search
  • Login
QuantumWarp QuantumWarp QuantumWarp
  • Home
  • Blog
  • Projects
    • QWcrm
    • Joomla
      • mod_helloworld
      • plg_helloworld
      • QWRealURL
  • KB
    • Articles
    • Links
  • Forum
  • Stuff
    • Links
  • Search
  • Home >
  • KB >
  • Links >
  • Applications >
  • Articles >
  • Microsoft Office >
  • Excel >
  • Duplicate Values >
  • How to delete duplicates and leave one of them | ASAP Utilities for Excel
Plusnet - Header Banner

How to delete duplicates and leave one of them | ASAP Utilities for Excel

I absolutely love this program. My main reason for using this program is finding duplicate serial numbers in a list of 12,000 without having insert a conditional formula every time. I see you can select, hide, or delete all the duplicates but is there anyway to delete the duplicates and leave one of them?

Yes there is. This will remove the duplicates leaving one original.
ASAP Utilities » Range » Empty duplicates in selection.

Listing Details

http://www.asap-utilities.com/blog/index.php/2005/09/29/how-to-delete-duplicates-and-leave-one-of-them/
Website
www.asap-utilities.com/blog/index.php/2005/09/29/how-to-dele...
Visited
80

Legal

  • Attribution
  • DMCA
  • Privacy & Cookies
  • Terms & Conditions

Resources

  • Feedback
  • Downloads
  • Typography

QuantumWarp

  • About
  • Contact

Follow Us

  • GitHub
© QuantumWarp 2020, Powered by Astroid. Developed by QuantumWarp