building list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

excel2003:
i have a range name SPH1 (='Salar'!$I$146:$I$2033)
it will cover all the weekly entry of values fed from our office.

i146 contains the header
i2033 is always empty.
i147:i2032 not empty with values 0+.

after one week the range will increase for about 100.

i need to create a dynamic list in a separate -Sheet1- like under a name of
SPHU (='Sheet1'!B:B).

SPHU must contain only the unique values entered in SPH1.
so, SPHU may look somethiing like this..
B1 will contain the header
B2:B#
e.g.( 0,401,500,502.5,650.33336,700,max!)

I will use this list from Sheet1 to review other existing workbooks -
somekind of validation work.
thanks and regards,
driller
 
How is this different from your other posting a few minutes ago?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

building list from a column of data 3
Dependent drop down dynamic range formula, off sheet. 7
Drop Down with dynamic named range offsheet source list 14
Cell highlighting question 4
How to get the cell reference of the value selected from name list 3
named range with criteria. 7
RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS 4
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Back
Top