I have the below formula which is looking for duplicates in a row and returning a 1 if there is a duplicate. This appears to be working fine except it's also counting duplicate blank cells. I need it to ignore blank cells if possible. Any ideas?
=IF(COUNTIF($H$9:$W$9, L$9)>1, 1, "")
=IF(COUNTIF($H$9:$W$9, L$9)>1, 1, "")