unique entries

[jammoca]

I have a list of names in the range F4:F1000

I'd like a list of each name (to appear only once) from G4 downwards.

I'm guessing some kind of array formula will be needed.

I can't do vba, so if there's a formula i can use, I'd be very greatful.

Kind regards,

Chris

 

[Andrew Poulsom]

Look here:

Create a unique distinct alphabetically sorted list, extracted from a column in excel | Get Digital Help - Microsoft Excel resource