Hey Everyone!!

Not sure if this is possible or not...

I am using the current code the define a name for a list:
=OFFSET(FIS!$V$4:$V$25004,0,0,SUMPRODUCT(--(FIS!$V$4:$V$25004<>"")),1)
The purpose behind the above code is to remove the blanks at the bottom, and works like a charm (thanx to the awesome experts of this forum!). What I am wondering is if it is possible to have it also remove duplicate values?

Thanx!!