Returning Cell Information

Status
Not open for further replies.

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
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,089
Members
412,310
Latest member
mark884
Top