Macro to delete Duplicate Records

[howard]

I have a spreadsheet containing numerous duplicate references. These aere contained in Col H. I would like a macro that will delere only one of the duplicate records. For EG if H25, contains Ref 145609 & H26 contains 145609, then the first row containing the duplicate record must be deleted

Your assistance will be most appreciated

 

[Walky]

Hi Howard,

I see that the reply I tried to send you a few hours ago didn't go through...

So replace this part of your formula:

H93="F?"

with this:

LEFT(H93,1)="F"

Excel will check the 1st (hence the "1") character starting from the left of what is displayed in the H93 cell to see if it is equal to the letter "F".

Btw, I didn't invent this solution, I found it while searching the web for more ways to use the "COUNT" function.

Regards,

W.

 

[Walky]

Hi again Howard,

I didn't read your request correctly...

In fact you need something like:

=IF(AND(COUNTIF(H:H,H3)>1,LEFT(H3,1)="F"),"1/1",COUNTIF(H$3:H3,H3)&"/"&COUNTIF(H:H,H3))

The "AND" part makes sure that both conditions (duplicate (more than 1 occurence) and begining with "F") are met, if it's the case, "1/1" is displayed, otherwise the COUNTIF formula is applied.

Regards,

W.

 

[howard]

Thanks for the help, the macro works perfectly. I would like you to amend your code, to exclude text, where the text starts with an Alpha character for Eg F1480

Your assistance will be most appreciated

 

[howard]

Hi Walky

Thanks for the help, formula works perfectly.