E
ecmx39
Can anyone recommend a way to display top 3 choices from a 3-D workbook
based on a selection from the 1st worksheet? What I am trying to do is
to set up a worksheet, (w1), from which text values are chosen, A and B
for example. sequential worksheets, (w2, w3, w4, w5, ...) in the
workbook contain numerical values associated with A, B, C, D, ... I
would like to write a formula that would display on worksheet 1 the top
3 values & worksheets that contain the maximum numerical values for A &
B, i.e. if w6, w9, & w22 contain the max values for A, then w1 would
display the values for A and the worksheets on which the values are
located. Also, the A & B are selected from a pull-down selection. Any
suggestions?
based on a selection from the 1st worksheet? What I am trying to do is
to set up a worksheet, (w1), from which text values are chosen, A and B
for example. sequential worksheets, (w2, w3, w4, w5, ...) in the
workbook contain numerical values associated with A, B, C, D, ... I
would like to write a formula that would display on worksheet 1 the top
3 values & worksheets that contain the maximum numerical values for A &
B, i.e. if w6, w9, & w22 contain the max values for A, then w1 would
display the values for A and the worksheets on which the values are
located. Also, the A & B are selected from a pull-down selection. Any
suggestions?