Hello All
Please see attached
The attached table is constantly changing, I need to display the top 10 part numbers by value items for each Area and Business unit.
I have given some 2 examples (highlighted in yellow, red, Blue, Orange)
So the formula needs to look at the 3 field and return the top valued item from the list
Area Business Unit Part
thanks in advance
Re: Sort Table data into Top 10 using multiple search criteria’s
something like this one with PivotTable?
Post updated - was wrong file
Last edited by sandy666; 03-16-2018 at 10:35 AM.
An alternative, with a couple of named ranges and dropdown boxes. BtW, there's a space after purchased parts in column A. Ideally, it should be removed and then removed from L2
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
[removed by me]
Last edited by sandy666; 03-16-2018 at 11:23 AM.
that's great, thanks
but which one?
Ehh???Originally Posted by sandy666
as usual, no thanks, no kiss my a***
pmw19800. Who were you talking to? If me, were you able to follow it all?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks