himperson1
New Member
- Joined
- Jun 23, 2016
- Messages
- 33
hello all,
i have a set of data within varying ranges on different pages (ie: data on sheet1 is within d18:d28, but similar data on sheet2 is within d24:d50, and on sheet3 within d30:d35)
i have already managed to find the largest 3 values among this range, but now i am trying to perform an index/match to find the accompanying label on column c (sheet1 c24:c50, etc).
i have tried to use http://www.mrexcel.com/forum/excel-questions/357517-large-function-across-multiple-worksheets.html as a resource, but their function operates when the sheets all use the same range.
im utterly stuck. would anybody be able to adapt this for my needs?
thanks.
i have a set of data within varying ranges on different pages (ie: data on sheet1 is within d18:d28, but similar data on sheet2 is within d24:d50, and on sheet3 within d30:d35)
i have already managed to find the largest 3 values among this range, but now i am trying to perform an index/match to find the accompanying label on column c (sheet1 c24:c50, etc).
i have tried to use http://www.mrexcel.com/forum/excel-questions/357517-large-function-across-multiple-worksheets.html as a resource, but their function operates when the sheets all use the same range.
im utterly stuck. would anybody be able to adapt this for my needs?
thanks.