Select the maximum

[#1]

Hi,

I need to select the last two maximum quarter in the multi box when moved to a particular sheet. My data for quarter will be (Q3'09, Q4'09, Q1'10,Q2'10, Q3'10). and all these are text fields. So, I need to select Q3'10 and Q4'10 automatically when moved to this sheet. I think this should be possible with the help of macro, but I have no idea on how to find the last two maximum.

Thanks

[#2]

Hello,

If you are using QV 9.00:

1. Right click on the sheet you want to add the event.

2. Select Sheet Properties.

3. Under the Triggers tab, select Edit Actions (OnActivateSheet).

4. Add the event Select in Field. In Field put the quarter column name. In Search String write: =MaxString(column_name, 1)

... that will give you the max quarter.

5. Add the event Toggle Select. In Field put the quarter column name. In Search String write: =MaxString(column_name, 2)

... that will give you the second max quarter.

When you use Toggle Select, it'll be selected the two maximum quarters.

Steve

[#3]

I am using 8.2 version. Is there way of doing it here.