NextWorldAngel
New Member
- Joined
- Oct 19, 2006
- Messages
- 31
Okay I need a formula that finds the max number in column D, if column B="Local" and then whatever the max # is in row ___ pull the entry in in that same row but from column A for the answer.
Example:
(Col. A) (Col. B) (Col. D)
1 ------Local-------- $50
2------- OTR------- $125
3------ Local------- $100
Answer would be 3.
Example:
(Col. A) (Col. B) (Col. D)
1 ------Local-------- $50
2------- OTR------- $125
3------ Local------- $100
Answer would be 3.