#### Gary Drumm

##### Active Member

- Joined
- Feb 22, 2005

- Messages
- 462

Column 1 is a list of about 300 equipment asset numbers, formatted as text.

I would like to check for duplicates. (Sample numbers might be 10H754, or 10G520)

In column 2 I used Andrew P's. formula =if(countif(A$1:A2,A2)=1,Max(B$1:B1)+1,"")).

In column 3 he uses =if(Max(B:B)<Row(1:1),"",Index(A:A,MAtch(Row(1:1),B:B,False))).

I copied those down, and both columns B and C have #Value! errors top to bottom.

It sort of works, I can change one of my asset numbers to be exactly like another, and it will read false, instead of Value.

I don't know how to get it cleaned up, to eliminate the #Value! errors.

A blank space would be better, easier to look at or scan.

What might work better?

I haven't worked in Excel for a while, and I'm very rusty.

Thanks,

Gary

I would like to check for duplicates. (Sample numbers might be 10H754, or 10G520)

In column 2 I used Andrew P's. formula =if(countif(A$1:A2,A2)=1,Max(B$1:B1)+1,"")).

In column 3 he uses =if(Max(B:B)<Row(1:1),"",Index(A:A,MAtch(Row(1:1),B:B,False))).

I copied those down, and both columns B and C have #Value! errors top to bottom.

It sort of works, I can change one of my asset numbers to be exactly like another, and it will read false, instead of Value.

I don't know how to get it cleaned up, to eliminate the #Value! errors.

A blank space would be better, easier to look at or scan.

What might work better?

I haven't worked in Excel for a while, and I'm very rusty.

Thanks,

Gary

Last edited: