Hi, I'm trying to use the IF function to compare who performed a task last (based on dates) and whose turn it is now to perform a task. For example, if A did the task on 11/01/16, B on 11/02/16, C on 11/03/16 and D on 11/04/16, the function should return A. A,B,C and D are in cells and there corresponding dates are adjacent to them.

re: " A,B,C and D are in cells and there corresponding dates are adjacent to them.""Adjacent" can be to the left or to the right of letters, so I'll cover both situations.

The following formulas should find the "lowest" date and return the letter in the corresponding Row.

A B C 1 A 11/1/2016 =INDEX($A$1:$B$4,MATCH(MIN($B$1:$B$4),$B$1:$B$4,0),1) 2 B 11/2/2016 3 C 11/3/2016 4 D 11/4/2016

A B C 1 11/1/2016 A =VLOOKUP(MIN($A$1:$A$4),$A$1:$B$4,2,0) 2 11/2/2016 B 3 11/3/2016 C 4 11/4/2016 D

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Shouldn't the sequence always be the same? If A starts then B, C, D.doesn't the sequence then simply repeat,

After D, the next should be A again, then B, C, D.Why do you need a formula?

MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll