Hi,
I've done a keyword search on deleting duplicates in this forum and i've found a few responses, but i've not found anything that covers the problem i'm currently facing.
I need to run a macro that will hunt for duplicates in column A of an Excel spreadsheet and i need it to delete the row where column N is blank. EG:
Column A Column N
a
b
a Y
c
d
d N
This should read:
Column A Column N
a Y
b
c
d N
Can anybody help?
I've done a keyword search on deleting duplicates in this forum and i've found a few responses, but i've not found anything that covers the problem i'm currently facing.
I need to run a macro that will hunt for duplicates in column A of an Excel spreadsheet and i need it to delete the row where column N is blank. EG:
Column A Column N
a
b
a Y
c
d
d N
This should read:
Column A Column N
a Y
b
c
d N
Can anybody help?