Here is what I am trying to do. We are migrating some databases from Town A
to Town B. I am trying to map these tables into different locations. I have
done this mapping saying

owner table_name file_name mb
camposad dw_participant clrptng_data02 47
camposad dw_consult clrptng_data02 34
camposad dw_prsn_addr clrptng_data04 27
camposad dw_care_sprt_kit_info clrptng_data03 24
camposad savings_d_t2_orig_calced clrptng_data03 22
camposad savings_d_t2_uncalced clrptng_data04 21


I also have some other info like the current size of the tables. I am
trying to get a distinct list of file names out of my spreadsheet. Once I
get this list, I would then like to sum up all of the table sizes in each
file, so we can know how big each file will be. I've been looking at trying
to use some sort of formulas, but not having a lot of luck getting the
distinct list together. I figure that once I get this list together, maybe
in another worksheet within my workbook, doing this sum should be relatively
straight forward. I would like to use something like a formula, because
after looking at the file sizes, we may move some tables around, and I would
like these numbers to be modified automatically. Im probably pushing the
limits of what I can do w/ excel.



"Ron Coderre" wrote:

If you want to effectively paste a list of the unique values
try this:

Your list will need a column heading. (eg Names)
I'll assume A1:A14 contains your list, with A1: Names

B1: Names

Select your list of values A1:A14

From the Excel main menu:
<data<filter<advanced filter
Check: Copy to another location
Copy to: B1
Check: Unique records only
Click the [OK] button

That will create a list of the unique names under cell B1

Is that something you can work with?

Note: There are also ways to have the list built on a different worksheet in
the workbook and to use formulas, instead of Advanced Filter.

Post back if you have more questions.
***********
Regards,
Ron

XL2002, WinXP


"cindi" wrote:

I am looking for a way to take a list of values from one column, and in
another column display a list of distinct items in this list.

So if in column A I have the following values:
Alan
Bob
Charlie
Alan
Alan
Alan
Charlie
Dave
Charlie
Bob
Edgar
Bob
Bob

In column B (or another worksheet or whatever) I am expecting a list like
this:
Alan
Bob
Charlie
Dave
Edgar

Is there a way to do something like this?

Thanks,

Cindi