Ignore blanks in a countif formula

[saraapple]

I need to amend my formula to ignore blank cells, but am struggling!

=IF(COUNTIF($L$2:$L$199, $L6)>1, "SPLIT", "")

This currently tells me if a name is repeated in col L and returns the value SPLIT - my new data has blanks and they are flagging incorrectly now, so I need to ignore them.

Any ideas would be greatly appreciated.

thank you
Sara

 

[Joe4]

Not quite sure I understand, but is this what you are looking for:

=IF(AND($L6<>"",COUNTIF($L$2:$L$199, $L6)>1), "SPLIT", "")

 

[saraapple]

That worked perfectly thank you so much.

 

[Joe4]

You are welcome.
Glad I was able to help.