Hi,
I have a list of different names/values in multiples of -n, however I find that the IF formula which I created is applying formulas incorrectly. (if(and(b3<b2, b3<b4), Column A1, 0)
I'll use 3 occurences of unique names as an example: Column A : Mike, Mike, Mike, John, John, John, Jane, Jane, Jane, Andrew, Andrew, Andrew, Peter, Peter, Peter, Jason, Jason, Jason.
In Column B: 1,1,1,2,2,2,3,3,3,4,4,4,5,5,5,6,6,6,7,7,7,8,8,8,9,9,9,10,10,10.
The trouble arises when I drag the formula down, and I'm exhausted working on this.
I have a list of different names/values in multiples of -n, however I find that the IF formula which I created is applying formulas incorrectly. (if(and(b3<b2, b3<b4), Column A1, 0)
I'll use 3 occurences of unique names as an example: Column A : Mike, Mike, Mike, John, John, John, Jane, Jane, Jane, Andrew, Andrew, Andrew, Peter, Peter, Peter, Jason, Jason, Jason.
In Column B: 1,1,1,2,2,2,3,3,3,4,4,4,5,5,5,6,6,6,7,7,7,8,8,8,9,9,9,10,10,10.
The trouble arises when I drag the formula down, and I'm exhausted working on this.