Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks

can you sort first

--
Don Guillett
SalesAid Software

"Novaglory" wrote in message
...
Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks

Hi Michael
thanks for the link- I'm working through one solution involving on VBA Code,
which i'm a newbie at, and my computer keeps hanging, but i'll keep trying.
Any other suggestions anyone?


"Michael" wrote:

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks

Hi. I have the same problem and that link doesn't work.

"Michael" wrote:

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks

Try the link again now.

Heidi wrote:

Hi. I have the same problem and that link doesn't work.

"Michael" wrote:


Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:


Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks