Hi,
Here is my data and formula
A B C
0:10:00 0:32:00 =if(b1=a1:a3,Break,N/A)
0:11:00 0:10:00
0:12:00 1:07:00
but the data from B column is formulas and not a typed value.
any suggestions
Hi,
Here is my data and formula
A B C
0:10:00 0:32:00 =if(b1=a1:a3,Break,N/A)
0:11:00 0:10:00
0:12:00 1:07:00
but the data from B column is formulas and not a typed value.
any suggestions
It sounds like you are trying to see if entry in column b exists anywhere in column a. If so
=if(not(iserror(match(b1,$a$1:$a$3,0))),"Break","N/A")
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks