I think that I would create a pivot table. If you put column A as your first
row field and column B as your second row field. This will give you a list
of only unique entries in column A, with all the corresponding data from
column B.




"Anders Axson" wrote:

Hello

If i have a list of dates in, say, column A, of a worksheet, several of
which are replicated, and the data in columns B onwards are unqiue, how do I,
on another sheet, lookup the dates and then get each entry, all in a list, in
chronological order? I'd then like to be able to delete an entry from the
sheet being looked up, and my lookup sheet updates to show the list without
the entry deleted?

Thanks