I need to compare two cells on the same row then output to a third cell if a difference is found.
If B1 does not equal A1 then output contents of A1 to C1
When checking if something is equal, whether it is uppercase or lowercase should be ignored.
I need to compare two cells on the same row then output to a third cell if a difference is found.
If B1 does not equal A1 then output contents of A1 to C1
When checking if something is equal, whether it is uppercase or lowercase should be ignored.
Last edited by gunk; 06-26-2013 at 01:01 AM.
in c1 typeif(b1<>a1,a1,"")
Thankyou RCM!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks