If I have two cells in A1 and B1
cat dog
In A5, I want to return the one that ISN'T "cat" (which I would set in a cell somewhere). So A5 would say "dog". How would I do that? Is this even possible?
If I have two cells in A1 and B1
cat dog
In A5, I want to return the one that ISN'T "cat" (which I would set in a cell somewhere). So A5 would say "dog". How would I do that? Is this even possible?
You could use this formula in A5:
=IF(A1="cat",IF(B1="cat","",B1),A1)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks