confusing formula

[deuce]

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.

 

[deuce]

I would appreciate if other Mrexcel MVP's and moderators can assist me to solve my queries

thanks in advance.