Averaging multiple ranges through multiselect listbox

[ZX210]

Averaging multiple ranges through multiselect listbox
I have a spreadsheet with a variable number of data columns. The name of the column imported into the spreadsheet is located at the top of the column data. A list box was then created that imported the column title as the name in the list box. How do I associate the column titles in a multiselect list box with the data in their columns?

Title 1 Title 2 Title 3 AVG
2 3 2
5 4 3

I want to be able to have a list box containing title 1, 2 and 3. I then want to be able to select multiple ranges by multiselecting Titles in the listbox such as Title 1 and 3. The averages should contain the average of the values in the same row for each column selected. Please advise. Further, some examples containing manipulation of multiselect listbox arrays would be appreciated so that maybe I could derive the code myself. Thanks for any assistance.

Mike Proia

michael.proia@usm.edu

 

[PHV]

multiselect listbox stands for multi-selecting ROWS, no columns.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244