Frank Bacchus
Member
Hi all:
This may be a simple answer:
I have an excel sheet with a key and a number. The only thing is the key repeats and the number may be different. I would like to do a vlookup and get (as a result) the highest number for that key. For example:
key - number
1 - 4
1 - 5
1 - 7 My vlookup result should be 7
2 - 10 My vlookup result should be 10
3 - 2 My vlookup result should be 2
4 - 6
4 - 7
4 - 9
4 - 11 My vlookup result should be 11
Simple - what is the vlookup formula?
thanks
frank
This may be a simple answer:
I have an excel sheet with a key and a number. The only thing is the key repeats and the number may be different. I would like to do a vlookup and get (as a result) the highest number for that key. For example:
key - number
1 - 4
1 - 5
1 - 7 My vlookup result should be 7
2 - 10 My vlookup result should be 10
3 - 2 My vlookup result should be 2
4 - 6
4 - 7
4 - 9
4 - 11 My vlookup result should be 11
Simple - what is the vlookup formula?
thanks
frank