I managed to acheive this by doing the following:

I define global variables for the current value of column A and Column C, and the current group by

var tColA = 0.0;

var tColC = 0.0;

var tCurrentGroupBy;

Then in my function, I do the following: