Averaging multiple ranges through multiselect listbox

Z

ZX210

I have a spreadsheet with a variable number of data columns. The nam
of the column imported into the spreadsheet is located at the top o
the column data. A list box was then created that imported the colum
title as the name in the list box. How do I associate the colum
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.
then want to be able to select multiple ranges by multiselecting Title
in the listbox such as Title 1 and 3. The averages should contain th
average of the values in the same row for each column selected. Pleas
advise. Further, some examples containing manipulation of multiselec
listbox arrays would be appreciated so that maybe I could derive th
code myself. Thanks for any assistance.

Mike Proia

[email protected]
 
F

Frank Kabel

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