Hoping someone can help me. I manage a process where everything should be done in a "first in / first out" basis.
I'm trying to easily identify instances of someone taking them out of order. I have a conditional format of "=a2<a1" and this is working great. However, it doesn't catch those instances were 2 or more were selected out of order. See the red item below.
Is there a way to have it look at the last date and time that wasn't out of order?
Capture.JPG
Try using:
=IF(A2="","",A2<>MAX($A$2:A2))
as you CF formula.
Last edited by Glenn Kennedy; 02-02-2017 at 07:44 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks