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




---
Message posted from http://www.ExcelForum.com/

Hi
not comletly sure but have a look if the combination of 'Data - Filter'
and the function SUBTOTAL does what you want

--
Regards
Frank Kabel
Frankfurt, Germany


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




---
Message posted from http://www.ExcelForum.com/