Hi,

i know i've done it in the past but i can't seem to figure out what the
formula is for this one.

I have a list based off of a query that can list multiple deparments in the
column i'm using for my validation. for example.

Department.
Streets N
Streets N
Streets N
Parks E
Parks E
Fire
Fire

What i want the validation to do i show only 1 Streets N instead of 3, 1
Parks E instead of 2, and 1 Fire instead of 2

Hope that makes sense.

Thanks,

Ben