Hello My Dear
Please bring the names in column I on the Summary page to column B on the Hotel page, provided that it is without repetition and on two conditions that the dates in columns D & E on the Summary page are equal to the month in cell T2 on the Hotel page... and the second condition is that the names of the hotels in column B on page Summary matches the name of the hotel in cell K2 on the Hotel page. Thank you very much, and may God bless your efforts
Please modify and correct this formula to make it work
Please bring the names in column I on the Summary page to column B on the Hotel page, provided that it is without repetition and on two conditions that the dates in columns D & E on the Summary page are equal to the month in cell T2 on the Hotel page... and the second condition is that the names of the hotels in column B on page Summary matches the name of the hotel in cell K2 on the Hotel page. Thank you very much, and may God bless your efforts
Please modify and correct this formula to make it work
Code:
IFERROR(INDEX(Summary!$I$2:$I$23,AGGREGATE(15,6,ROW(Summary!$I$2:$I$23)/(Summary!$B$2:$B$23=$K$2)/(Summary!$D$2:$E$23<=$T$2)/(COUNTIF(B$5:B5,Summary!$I$2:$I$23)=0),1)),"")
Attachments
Last edited by a moderator: