It is in a database, but am using Excel to pull some formatted reports.
Here is a better example, for multiple builders:
Ryan
Ryan Townhomes
Ryan 60'
Mulvaney - Greenbrier
Mulvaney - 80
KB Home
KB Home 70'
I need to extract the unique values to give me:
Ryan
Mulvaney
KB Home
What I am doing is about impossible in Access, as it is pulling lot data
into a formatted report spread over a 6 year rolling period. I would still
have the same issue in Access as well if I were to query the data for these
values.
Thanks!
wrote in message
oups.com...
what do you mean by reverse concatenation?
ps - you should be storing DATA in a DATABASE and not in excel.
-Aaron
|