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
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