Defined range using more than one column

P

Pat

Can anyone tell me if it is possible to have two or more columns in a
defined range. I want to have a dropdown validation list where two or more
columns of data is displayed on the dropdown list. When an item is selected
in the dropdown list only one of the columns data is displayed in the cell.
Is this possible and how is this accomplished?
Or if there is a different approach I should go down please let me know.

Thanks
Pat
 
T

Tom Ogilvy

You can have a defined range with two or more columns, but that won't show
up in Data=>Validation using the list option. You might want to look at the
Control Toolbox Toolbar Combobox or Listbox.
When an item is selected
in the dropdown list only one of the columns data is displayed in the
Click to expand...
cell.

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column values
to the single cell or write the row in the combobox dropdown across multiple
cells.
 
J

Jason Morin

Try SUMIF. For example, let's say your dates are in col.
A, values to sum in col. B, and all this is in a sheet
named "mysheet". With a date in A1 of a new sheet, use:

=SUMIF(mysheet!A:A,A1,mysheet!B:B)

HTH
Jason
Atlanta, GA
 
P

Pat

It is unclear if you are saying this is what you want, or you are
complaining that this is what happens and not what you want. It certainly
is what happens and there is no way around that unless you use code to
interpret the selection and write a concatenated string of the column
values
to the single cell or write the row in the combobox dropdown across
multiple
cells
Click to expand...

Yes this what I want and I am happy with that.

Do you happen to know if there is examples of what you suggest on the web?
 
P

Pat

I have tried you suggestion and was unsuccessful only a date 00-01-1900 was
returned from the formula. Am I missing something here?
 
Top