gregory666
New Member
- Joined
- Sep 9, 2005
- Messages
- 16
Thanks Eric for trying to help; for some reason after downloading the HTML, I can not open it.
Anyway, I have simplified my question further. Suppose the following three column list:
Quanity Address Phone
50 xyz 914-8**-0000
45 xyb 914-8**-0000
2 xyo 914-8**-0000
What I am trying to do is associated an address from one huge list with a list of phone numbers. My criteria would be to select the largest quantity (50), associated with a unique phone number 914-8**-0000, and return the address from the cell associated with it.
Greg
Anyway, I have simplified my question further. Suppose the following three column list:
Quanity Address Phone
50 xyz 914-8**-0000
45 xyb 914-8**-0000
2 xyo 914-8**-0000
What I am trying to do is associated an address from one huge list with a list of phone numbers. My criteria would be to select the largest quantity (50), associated with a unique phone number 914-8**-0000, and return the address from the cell associated with it.
Greg