Countif - look for duplicates and ignore blanks

[Jasesair]

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, "")

 

[maabadi]

How about:

=IF(COUNTIFS($H$9:$W$9, L$9, $H$9:$W$9,"<>" &"")>1, 1, "")

 

[Peter_SSs]

I gather that your blanks must actually be formulas returning ""?
If that is so then @maabadi's formula will have the same issue.

My suggestion is

=IF(L$9="","",IF(COUNTIF($H$9:$W$9, L$9)>1, 1, ""))