Loop over two columns

Hi

I would like to be able to loop over two columns at a time and perform some analysis on each pair of columns (which would then be appended to create a final analysis file).

The dataset would be as follows (smaller extract provided due to size of file):

TEST DATA.xlsx

So the loop would look at columns A&B first, then C&D, E&F and each analysis step would add a flag of 1 if the Level (%) was greater than 100. For each pair of columns I would like the output file to take the header from the first column (i.e. from columns A, C, E) and sum the number of flags (I know the sum will be zeros based on the limited dataset).

Thanks

Chris