| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find MAX number with criteria
Hello all:
Using Excel 2003 I have two lists, column A contains a list of names that have reoccurrences of the same name many times within the list and I’ve already made a list in column E of those unique names. Column B is a list of numbers in random order and no two numbers are the same. My problem is trying to make a new list in column F by finding the MAX number in column B that is associated with the persons name in column E. I’ve tried many different formulas with no success, can any one please help me out with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find a column number using variable criteria? | Excel Worksheet Functions | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Threaded Mode
