Hello,
I've got rows that are sorted by products sales, best to worst, and then columns with each customer's sales for those products in the columns. I'm trying to find out how to return the top three products without sales in them for each customer. I think it's some kind of array formula, but I'm not sure how to work.
I've attached a file to show what I mean (some color coding added to indicate relationships)
Thanks for any help with this,
Daniel
see attached file.
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
In C1, copied across and dnown:
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW(C$6:C$21)/(C$6:C$21=""),ROWS(C$1:C1))),"")
I didn't look at Modytranes's solution, as i didn't want to download the file for a second time!! It may be the same... or different.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks so much, exactly what I was looking for!
Another brilliant solution - thanks so much for your help!
- Daniel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks