I have a spreadsheet with the following data<Pre> week1 week2 week3 week4
Australia 20.2 20.4 20.4 20.5
New Zealnad 18.6 21.5 18.6 25.1
Aust Ave 19.5 19.7 19.9 19.8
NZ Average 20.5 25.5 21.5 20.5</pre>
I want to use the index formula so that i could graph the data using a combobox.
I am using this formula "=index(b2:b5,a5)". My combo box is attached to a list of places, but when i run the combo box it returns the wrong line of data because of all the averages (lines 3 & 4 etc). How can i eliminate this problem so that it only reads the place data. Thanks
This message was edited by Juan Pablo G. on 2002-10-14 22:18
Australia 20.2 20.4 20.4 20.5
New Zealnad 18.6 21.5 18.6 25.1
Aust Ave 19.5 19.7 19.9 19.8
NZ Average 20.5 25.5 21.5 20.5</pre>
I want to use the index formula so that i could graph the data using a combobox.
I am using this formula "=index(b2:b5,a5)". My combo box is attached to a list of places, but when i run the combo box it returns the wrong line of data because of all the averages (lines 3 & 4 etc). How can i eliminate this problem so that it only reads the place data. Thanks
This message was edited by Juan Pablo G. on 2002-10-14 22:18
