Hey

This is more a mathematical problem I guess rather than a how to do it in VBA. I'm trying to write a simple macro that will allow me to highlight people who are nominating each other for small awards. Basically I get a copy of the datafeed from the server and run it in Excel on a monthly basis. I have a Nominator ID and a Recipient ID along with numerous other information and I want to be able to find out if anyone is continuously nominating each other? Been playing about with IF statements and loops but having no joy at all :( Just not mathematically minded enough!

Nominator Recip Amount Date Reason etc...
Scott Louise $20 12/01/06 .......
Louise Scott $20 1/01/06
Jack Jones $20

Any ideas as to the best approach? Any help as always is greatly appreciated!

Scott

Hello Scott,

Are you interested in who has nominated who the most number of times, or who has made the most nominations regardless of who they nominated.

If it is the latter, then just count the number of occurrences of each name in Nominator column.

If the former then you have to match pairs, ie Scott-Louise. See how many time Nom Col is Scott AND Recip Col is Louise or in pseudo code:

IF NomCol="Scott" AND RecipCol="Louise" THEN

scotLouiseCount=scotLouiseCount + 1

END IF

This is is only my first thought, I am sure there are other ways.

Chas

Hi thanks for the reply. Yes thats got me thinking the right way now. I am trying to highlight if people are nominating each other i.e. scott nominates louise for an award then louise nominates scott for an award, do you know what i'm saying? I can't get my head around how it can be done!

Any ideas? :)