process of elimination of duplicate information
 

i want to delete side by side cells that have the same information and leave
the single entre information cells.

cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789

cell 1,2,3,4 would be eliminated and only cell 5 would remain.

Thank you.

process of elimination of duplicate information
 

Manny

If you use a helper column alongside your current data and enter

=COUNTIF($A$1:$A$1000,=A1)

This assumes you data is in A1:A1000, this will put a number greater than 1
alongside all the dupes, you can then filter or sort by that and delete

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Manny" wrote in message
...
i want to delete side by side cells that have the same information and
leave
the single entre information cells.

cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789

cell 1,2,3,4 would be eliminated and only cell 5 would remain.

Thank you.

process of elimination of duplicate information
 

WHAT IS A HELPER COLUMN? DO I PUT THE FORMULA IN COLUMN A?

"Nick Hodge" wrote:

Manny

If you use a helper column alongside your current data and enter

=COUNTIF($A$1:$A$1000,=A1)

This assumes you data is in A1:A1000, this will put a number greater than 1
alongside all the dupes, you can then filter or sort by that and delete

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Manny" wrote in message
...
i want to delete side by side cells that have the same information and
leave
the single entre information cells.

cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789

cell 1,2,3,4 would be eliminated and only cell 5 would remain.

Thank you.

process of elimination of duplicate information
 

Select column B
Insert a new column (it'll be a new column B)

Put the formula in B1 and drag down as far as you need it.

But use this modified formula:

=COUNTIF($A$1:$A$1000,A1)

A helper column is just a column that you're gonna use to help you find the
answer you want. For me, I usually insert my helper column right next to what I
want to use.

But you can do insert that column whereever you want--to the far right if you
want it out of the way.

Manny wrote:

WHAT IS A HELPER COLUMN? DO I PUT THE FORMULA IN COLUMN A?

"Nick Hodge" wrote:

Manny

If you use a helper column alongside your current data and enter

=COUNTIF($A$1:$A$1000,=A1)

This assumes you data is in A1:A1000, this will put a number greater than 1
alongside all the dupes, you can then filter or sort by that and delete

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Manny" wrote in message
...
i want to delete side by side cells that have the same information and
leave
the single entre information cells.

cell 1 = 123
cell 2 = 456
cell 3 = 123
cell 4 = 456
cell 5 = 789

cell 1,2,3,4 would be eliminated and only cell 5 would remain.

Thank you.


--

Dave Peterson