Hi,

I am hoping someone can give me a hand.

I have a table of data, 100 rows and 6 columns wide. Each row of data will look something like this:

ch ph bi fr gh it

what i need to do is loop through each row and check for each pair e.g. ch+ph, ch+bi, ch+fr ... ph+bi

I then have to how many of these pairs exist all together. so I have made another table which needs to be updated with this data.

I have never really had to use vba before so I don't know what commands I can use to achieve this.

I don't know if there are built in functions that would make this task quite simple or if I am going to have to stimpulate each pair etc. something like this

IF EXISTS ch AND ph IN ROW THEN ADD 1 TO CELL A1
IF EXISTS ch AND bi IN ROW THEN ADD 1 TO CELL A2

any help would be much appreciated.