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.

 

[Fluff]

hope this helps.

Not in the slightest I'm afraid. You have still not clearly explained what you are trying to do, nor have you posted any data showing expected results.

 

[deuce]

okay, i fixed part 1 of the problem myself, now there is part 2 which is to apply the formula on names & based on date...lol

 

[Fluff]

As you seem to be totally ignoring me & have not done anything I have asked, I cannot help.

 

[deuce]

hi fluff, Please forgive me if you think that i'm ignoring you. I would never do something like that to anyone here.

 

[deuce]

I solved that part of the problem with the statement. if(a3=a4, a4=a5 etc. then the formula worked as expected, but having the same 100 names in the column and using a3=a4, a4=a5, is there a way to improve it so that it becomes if(a3=a4:A100)?

kind regards

 

[Fluff]

is there a way to improve it so that

I have absolutely no idea, because you have still not answered my questions, or provide samples.

 

[deuce]

okay, let's restart. what questions are to be answered?

 

[Fluff]

See posts#2 & 7 among others.

 

[deuce]

test

 

[deuce]

I will not install plugins on my computer sorry!