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
=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