rsutton1981
New Member
- Joined
- Mar 9, 2016
- Messages
- 47
- Office Version
- 365
- Platform
- Windows
Hi,
I am looking for a code that will look for a parameter in a column, search another sheet for all instances of the parameter and then find the maximum value recorded against the parameter.
e.g
in the review sheet I have a column with apples, oranges, etc
I want to search the assessment sheet for all instances of apples and then take the maximum value in Column L, and place it next to the apples in the review sheet.
I also need the same calculation to do the average rather then the max.
This has had me stumped all day.
Thanks in advance
I am looking for a code that will look for a parameter in a column, search another sheet for all instances of the parameter and then find the maximum value recorded against the parameter.
e.g
in the review sheet I have a column with apples, oranges, etc
I want to search the assessment sheet for all instances of apples and then take the maximum value in Column L, and place it next to the apples in the review sheet.
I also need the same calculation to do the average rather then the max.
This has had me stumped all day.
Thanks in advance