View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gmunro gmunro is offline
external usenet poster
 
Posts: 34
Default Top Ranked Opportunities

Hello,

I have a list that will be variable in length of all my accounts.
Let's assume I sell Bread Milk and Butter
I want to know of all my customer base, of the ones that are NOT buying
Bread, which ones buy the most milk or most butter, thus that I have a
better relationship with.

Can I do this with an IF rank feature?
Look at only those with zero sales in one category but the highest rank
in another?

Please help,

Glen Munro