I'm not sure if this is possible or if there's a better way to do it than what I'm currently thinking.
I have a data set comparing medical orders placed in our system to our staff's individual records of orders placed. e.g.
date name mr# test 1 ordered test 2 ordered test 3 ordered test 4 ordered 2/20/2014 jane doe 123456789 2/20/2014 7/5/2014 11/30/2014 4/1/2014 jane doe 123456789 2/20/2014 7/5/2014 11/30/2014 3/5/2014 john doe 987654321
What I would like to do it have a way to automatically find any rows in which "date" is not equal to "test 1 ordered" or "test 2 ordered" or "test 3 ordered" or "test 4 ordered"
I was thinking conditional formatting would be an easy way to do this, but I haven't had any luck yet. If anyone knows of any other solutions, please let me know.
Thanks!
Bookmarks