I use the following formula in column M to find duplicate values in column L
=COUNTIF(L:L, L2)>1
The formula works correctly with returning values of TRUE or FALSE
I would like to add an exception to this formula.
I would like a value of FALSE to be returned when the word "offline" is found.
This value will exist in column L many times and I want it overlooked.
=COUNTIF(L:L, L2)>1
The formula works correctly with returning values of TRUE or FALSE
I would like to add an exception to this formula.
I would like a value of FALSE to be returned when the word "offline" is found.
This value will exist in column L many times and I want it overlooked.