• 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.

Look up top 6 highest value based on code occurance for a matching string

kuldeepjainesl

kuldeepjainesl

Member
Please refer the attached file for example. Expected results are the top 6 values based on the occurrence of the Codes in E coloum for the Matching criteria available in "G1" when checked in coloum D.
 

Attachments

Just a thought : is it possible to use wild card match in this approach for code match. Actually in the data i will have a string of 10 to 15 Chr and i will check them for their first 10 digits.
 
@kuldeepjainesl

Really excuse me, I could not got time to work on it. Will update something by tomorrow. Meanwhile can you check your last uploaded file, Names are all same??? Can you also illustrate with output sample for any one name what exactly your output will look like.

Regards,
 
Attachment is right. refer coloum F and the results are in G coloum. Just the difference is that in initial version we match the whole string available in F and now we want to match first 10 chr of the string.
 
You must log in or register to reply here.
Back
Top