Formula to return multiple matches within a range, ranked
I have a raw data that lists country, product, and individual transaction values in columns A, B and C respectively.
I am hoping to use a formula to list out all matches in column C from large to small for a certain product sold to a certain country, is this possible without using macro? Ie. IF X matches col A and Y matches col B, return all matches from col C, ranked descending order.
Some alternative methods that didn't work/not feasible for me:
Filters: My report has somany countries x product combinations that it is too laborious to filter country/product one by and then copy and paste
Pivot table: I couldn't split individual transaction values out and rank them, then have a formula that draws specifically the Nth largest value in the range.
Extract of spreadsheet attached below, yellow cells are the ones that I need to replace with a formula.
Any help would be greatly appreciated, thank you very much in advance!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By dma1976 in forum Excel Formulas & Functions
Last Post: 05-02-2014, 07:38 AM
By simmo86 in forum Excel General
Last Post: 03-03-2014, 10:03 PM
By TC1980 in forum Excel Formulas & Functions
Last Post: 07-03-2013, 07:39 AM
By bkwins in forum Excel Formulas & Functions
Last Post: 04-12-2013, 04:57 AM
By a.mack123 in forum Excel Programming / VBA / Macros
Last Post: 09-18-2011, 10:07 AM
By GaidenFocus in forum Excel General
Last Post: 11-23-2010, 12:37 PM
By Wiggz in forum Excel General
Last Post: 01-25-2007, 06:42 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1