If the ID appears once or twice add a 6 to column F

[djfscouse]

Hi,

If the ID appears once or twice in Column A then add a 6 to column H, but if the ID appears 3 or more times in column A then do nothing.

I would like to use VBA only for excel 2003 because it will be added to a larger VBA later.

Thanks to Tigeravatar earlier I received the following code which works great for adding a 6 for each ID that appears.

So if somebody could suggest a way to make only work for the ID appearing either less than 3 times, otherwise the value in column F should be 0.

Please Login or Register  to view this content.

End Sub

David

[djfscouse]

Could somebody take a look above and see if they can help.

[nilem]

Hi David
try it

Please Login or Register  to view this content.

[djfscouse]

Hi nilem,

Thank you for your response, unfortunately it did not work because I put the wrong column down in my initial description of the problem, appologies!

I have attached my file with the working VBA as a module, but I need it only to add a 6 in column H only if the ID in column A appears once or twice, but if it appears 3 or more times then it should just add a 0 or do nothing.

Thanks again for any help,

David

[nilem]

maybe so

Please Login or Register  to view this content.

[djfscouse]

Absolutely perfect! Thanks again nilem.