How to remove all but 1lines that share a common cell

[Sirritys]

Ok that was bad topic. Here is the scenario:

I have lots of rows (>1000) and I only need 1 row / all occurrences of
"123" in first column

So the result would be a sheet where there would be no lines that share
same value in column A. (lines with dublicate instances would be
deleted)

Regards,
Sirritys

 

[Bob Phillips]

Look at Data>Filter>Advanced Filter. It has an option to copy unique rows
only.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Pete_UK]

You could apply autofilter for column A, selecting the value "123".
Highlight all the rows except the first one which contain "123", then
Edit | Delete Row, then select "All" in the autofilter drop-down (or
another value and repeat the procedure).

If you have a lot of values in column A it would be better to apply a
macro to do the deletions.

Hope this helps.

Pete

 

[Sirritys]

Heh, I was stupid this is easier than I thought

I just made extra column with formula =IF(B2=B1;1;0), then just arrange
based with that value and delete all "1"valued rows ;-)


Thanks thought =)

 

[Pete_UK]

Yes, but your list needs to be sorted first for this to work.

Pete