COUNTIF Exclusion Logic

[meppwc]

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.

 

[Joe4]

I am a little confused as to what you are asking.
Are you saying when "offline" is found cell L2, you want to return FALSE?
Or if it combined with other things in column L?

It may be best to provide a simple example to show us what you are after.

 

[Fluff]

How about
=IF(L2<>"offline",COUNTIF(L:L, L2)>1)

 

[meppwc]

Thank you Fluff..........that is exactly what I needed

 

[Rick Rothstein]

Another possibility (note the "S" at the end of "COUNTIFS")...

=COUNTIFS(L:L,L2,L:L,"<>Offline")>1

 

[Fluff]

Thank you Fluff..........that is exactly what I needed

You're welcome & thanks for the feedback