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

Need Display Data

Kenshin

Member
Hi friends on a few days or weeks ago I was asking help on this link

https://chandoo.org/forum/threads/display-data.36987/#post-222174

and got help from Bosco, but on my examples workbook, when i implemented on my real workbook it doesn't, and i still need your help again Bosco or other Ninjas member. For clearer explanation im attaching the workbook and the desired results

thanks
Kenshin
 

Attachments

  • HELP.xlsx
    236.6 KB · Views: 6
Just change the highlighted red number, then copied right and down :

=IFERROR(INDEX(Data!C$2:C$10001,AGGREGATE(15,6,ROW(Data!$C$2:$C$10001)-ROW(Data!$C$1)/((Data!$C$2:$C$10001=$A$3)+(Data!$D$2:$D$10001=$A$3)),ROWS($1:1))),"")

Regards
Bosco
 
Back
Top