Solved Nested if for dates?

November 9, 2016 at 10:59:11
Specs: Macintosh
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.

See More: Nested if for dates?

Report •

#1
November 9, 2016 at 11:59:04
✔ Best Answer
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.


Report •

#2
November 9, 2016 at 12:08:11
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

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question