r_johnston
asked on
Return 1st & 2nd common column B numbers based on 1st & 2nd common column A numbers
Hi experts,
I have an excel file that I have been working for analyzing data and I have run into a wall.
I need help developing the formula in Excel to return the 1st and 2nd most frequent numbers in a column based on the 1st and 2nd most frequent numbers in another column.
Please refer to the attached spreadsheet for better explanation...
To acquire the points for this question I will need a working formula
Many thanks!
Example.xls
I have an excel file that I have been working for analyzing data and I have run into a wall.
I need help developing the formula in Excel to return the 1st and 2nd most frequent numbers in a column based on the 1st and 2nd most frequent numbers in another column.
Please refer to the attached spreadsheet for better explanation...
To acquire the points for this question I will need a working formula
Many thanks!
Example.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Closer to a solution - the pivot table now has rank
How to add rank to Pivot Table
http://blogs.office.com/b/microsoft-excel/archive/2010/11/02/add-rank-to-pivottable.aspx
New file with rank attached
Book1.xls
How to add rank to Pivot Table
http://blogs.office.com/b/microsoft-excel/archive/2010/11/02/add-rank-to-pivottable.aspx
New file with rank attached
Book1.xls
ASKER
This worked like a charm!
Thanks both of you for answering!
Thanks both of you for answering!
This supplies all of them and just not the top two. I need to think some more about how to get just top two.
Book1.xls