I have a list of the format:
The list is created from a database via MS Query, sort order 1,2.
The vales for ITEM and DATE will vary each time the query is
I would like to setup a range that contains only a list of the grouped
by ITEM. I could do this with another query (select distinct ITEM
from X), but the queries take to long. How can I do this with excel
The required dataset (from the above example):
Thanks in advance,