Pages

Search

Excel Help Forum - Excel General: Need to look up a name in one column and return a maximum value from the next...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Need to look up a name in one column and return a maximum value from the next column
I have a list of names of different people in one column. Their names occur more than once in the list. The list is not sorted alphabetically. In the next column are values for amounts they have spent on different occasions. I want a formula that helps me to identify the maximum value they...