• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Populate the Nth Large Value

fareedexcel

Member
Dear Expert,

I need to find the Top nth value from a set of data by combining with 2 criteria.

Please find attached sheet with example.
 

Attachments

  • Try Large Func.xlsx
    839.7 KB · Views: 6
Hi,

Pls check attached file if it is ok for you..
I have added extra column "A" in your master sheet to convert your details in to a unique count and used "Vlookup formula" only
Also note that i have deleted most of of data from your master sheet as the file is too large and it is not allowed to upload

regards
Naresh
 

Attachments

  • Try Large Func (1).xlsx
    160.6 KB · Views: 9
Hi,

Pls check attached file if it is ok for you..
I have added extra column "A" in your master sheet to convert your details in to a unique count and used "Vlookup formula" only
Also note that i have deleted most of of data from your master sheet as the file is too large and it is not allowed to upload

regards
Naresh
Thanks Naresh for your Support. Brilliant !!
 
See attached (pivot table solution).
Dear Expert, I was thinking instead of selecting from Drop down is it possible to do with Slicer and you have made it. I'm feeling happy with your results and at the same time i want to learn VBA Macros. But i'm not even good with formulas :(

Anyhow thanks for your support Genius !!
 
Back
Top