Return a table of different times to a single vertical alphabetical list

[sgreenprice]

Good morning,

I have a problem where I have a table of varying times and need to convert them automatically to a single vertical alphabetical list (excluding outliers!). I expect I'll be using the MATCH and INDEX functions but I'm at a loss when there is a table of data rather than a list.

I have attached a screenshot of the problem - any help would be truly truly appreciated!

Best Regards,
SGP

 

[oldbrewer]

Re: Return a table of different times to a single vertical alphabetical list - Please help!

reduce range of cells copied by filling screen more please - it is unreadable

 

[sgreenprice]

Re: Return a table of different times to a single vertical alphabetical list - Please help!

I tried to attach the actual file but I couldn't see a function to do this. Anyway I've found a solution now, thanks for your response anyway.

Best Regards
SGP