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

Equation of bringing the Company Name between two Dates without Repetition

Hany ali

Active Member
Peace be upon you my dear friends and professors ... Please kindly help me find and bring the company name in the third column C of the Main page to the first column A of the Final page based on the dates in the two columns B & C of the same page, provided that the company name is on these two dates once Any without repetition, and thank you very much
 

Attachments

  • Company.xlsm
    15.2 KB · Views: 3
  • Untitled.png
    Untitled.png
    105.9 KB · Views: 9
Hell-You can use this
Code:
=IFERROR(INDEX(Main!$C$3:$C$7000,AGGREGATE(15,6,ROW($A$1:$A$6997)/(MATCH(Main!$C$3:$C$7000&Main!$E$3:$E$7000,Main!$C$3:$C$7000&Main!$E$3:$E$7000,0)=ROW($A$1:$A$6997)),ROWS($1:1))),"")
 

Attachments

  • Company1.xlsm
    15.5 KB · Views: 4
Back
Top