Main Area and Open Discussion > General Software Discussion

delete rows with duplicate cells

(1/2) > >>

kalos:
hello

in an excel file, I want to delete the rows that contain duplicate cells in the column H

is there any solution for this?

thanks!

tomos:
There seems to be a couple of options here:
http://duckduckgo.com/?q=excel+delete+rows+that+contain+duplicate+cells+in+one+column

Stoic Joker:
Shorter answer (less reading)

Highlight that data you want to work with, and click the Remove Duplicates option on the Data tab of the ribbon (07 and up). Then select the column(s) you want to search for duplicates.

...I just discovered this option a while back ... Right after spending an entire day manually sorting down a 7,000 item inventory dump. :wallbash:

Target:
lots of answers to this one (use the inbuil functionality, or formulas and filtering, or a macro, or...) but it depends on what you want to do

the version of excel you're using is relevant as well

Highlight that data you want to work with, and click the Remove Duplicates option on the Data tab of the ribbon (07 and up). Then select the column(s) you want to search for duplicates.-Stoic Joker (November 05, 2013, 06:59 AM)
--- End quote ---

worth noting that this only works in excel 2007 and above

kalos:
unfortunately I don't have excel, I use libreoffice latest version

is there a solution for that software?

Navigation

[0] Message Index

[#] Next page