Max,
Thank you. This is a very easy solution to this problem. It is easily
expandable automagically to varying size of list, (Not being an array
formula), and it works for me (something the other solutions have not done.
Thanks Again!
Larry

"Max" wrote:

Another way to extract the uniques list dynamic in another sheet
using simpler non-array formulas ..

Source data in Sheet1's col C (file_name), running in C2 down

In another sheet,

Put in A2:
=IF(Sheet1!C2="","",IF(COUNTIF(Sheet1!$C$2:C2,Shee t1!C2)1,"",ROW()))
Leave A1 blank

In B2:
=IF(ROW(A1)COUNT(A:A),"",INDEX(Sheet1!C:C,SMALL(A :A,ROW(A1))))
Select A2:B2, fill down to the max expected extent of data in Sheet1's col
C. Hide away col A. The uniques list of file_names will be extracted in col
B, all neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cindi" wrote:
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.