Count Same Or Duplicate Values Only Once

Hi everyone,

I'm using this formula to count same or duplicate values only once.
As of now its working fine for a specified range i.e E48:E57
Whereas I want it to work for a visible range in a table when filters are applied.

Secondly, I want to exclude a term 'CODE' if it ever appears in a column.

=SUMPRODUCT((E48:E57<>"")/COUNTIF(E48:E57,E48:E57&""))

Can someone please make it work or may be you can write a new code.

Thanks