I have a template that I use that does a VLOOKUP against the item description
from the data I pull. Issue I'm running across is that I have several items
that have the exact same description so the VLOOKUP is pulling that data from
the first description it finds. My work around right now is to manually
change the description of the items that are currently sharing the same
description. There are several items that are this way so it is very time
consuming. Is there a quicker way to change the similar cells in my data?

Do you want to find 'same descriptions'?

There are different ways...
1. Sort them, then in the next cell, starting at row 3 (assuming row 1 is
for headers) use
=IF(A2=A1,"Duplicate","")
and copy down... this way all duplicates are marked.

or
2. Use
=Countif(A:A,A2) in B2 and copy down
Duplicates will have a count greater than 1...


"Supe" wrote:

I have a template that I use that does a VLOOKUP against the item description
from the data I pull. Issue I'm running across is that I have several items
that have the exact same description so the VLOOKUP is pulling that data from
the first description it finds. My work around right now is to manually
change the description of the items that are currently sharing the same
description. There are several items that are this way so it is very time
consuming. Is there a quicker way to change the similar cells in my data?

I can find the duplicates. I just trying to find out if there is a better
way to change the duplicates other than manually going in and changing each
one.


"Sheeloo" wrote:

Do you want to find 'same descriptions'?

There are different ways...
1. Sort them, then in the next cell, starting at row 3 (assuming row 1 is
for headers) use
=IF(A2=A1,"Duplicate","")
and copy down... this way all duplicates are marked.

or
2. Use
=Countif(A:A,A2) in B2 and copy down
Duplicates will have a count greater than 1...


"Supe" wrote:

I have a template that I use that does a VLOOKUP against the item description
from the data I pull. Issue I'm running across is that I have several items
that have the exact same description so the VLOOKUP is pulling that data from
the first description it finds. My work around right now is to manually
change the description of the items that are currently sharing the same
description. There are several items that are this way so it is very time
consuming. Is there a quicker way to change the similar cells in my data?