I have a list of the format:
ITEM DATE
---- ----
UK 200401
UK 200402
UK 200403
UK 200404
UK 200405
IT 200401
IT 200402
... ......
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
refreshed.
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
functions?
The required dataset (from the above example):
ITEM
----
UK
IT
Thanks in advance,
Chris
Bookmarks