C
Craig Brandt
I routinely create lists and frequently I come across duplicates. I have
written routines to find these duplicates and ensure that I end up with only
one copy on each item, but many times the problem just dosen't warrant the
effort so I am looking for the most efficient way of handleing the problem
manually.
Problem:
I have a multi column download where column "A" is the Keyword where I do
not want duplicates.
Current solution:
I manually sort the list by column "A".
Insert column "B".
put formula in "B2" =if(A1=A2,"","X")
Delete any row with an "X".
Problem:
when I do this I get a #REF! error in the following formula because I
deleted it's reference point.
Request:
Is there a way that I can write the same formula that says compare the cell
to the immediate left to the cell to the left and one up permitting me to
delete that row and the formula will simply compare to the new cell
one-over-and-one-up?
Any help or alternatative method would be greatly appreciated.
Thanks in advance,
Craig
written routines to find these duplicates and ensure that I end up with only
one copy on each item, but many times the problem just dosen't warrant the
effort so I am looking for the most efficient way of handleing the problem
manually.
Problem:
I have a multi column download where column "A" is the Keyword where I do
not want duplicates.
Current solution:
I manually sort the list by column "A".
Insert column "B".
put formula in "B2" =if(A1=A2,"","X")
Delete any row with an "X".
Problem:
when I do this I get a #REF! error in the following formula because I
deleted it's reference point.
Request:
Is there a way that I can write the same formula that says compare the cell
to the immediate left to the cell to the left and one up permitting me to
delete that row and the formula will simply compare to the new cell
one-over-and-one-up?
Any help or alternatative method would be greatly appreciated.
Thanks in advance,
Craig