Re: การทำsearch
Posted: Mon Oct 21, 2019 10:23 am
=IFERROR(INDEX(Sheet1!D:D,MOD(AGGREGATE(15,6,COUNTIF(Sheet1!$D$2:$D$9999,"<="&Sheet1!$D$2:$D$9999)*10^10+COUNTIF(Sheet1!$E$2:$E$9999,"<="&Sheet1!$E$2:$E$9999)*10^5+ROW(Sheet1!$E$2:$E$9999)/(Sheet1!$C$2:$C$9999=$S$2)/(Sheet1!$A$2:$A$9999=$A$1)/ISERROR(MATCH(Sheet1!$D$2:$D$9999&Sheet1!$E$2:$E$9999,$A$10:$A10&$B$10:$B10,)),1),10^5)),""รบกวนช่วยดูให้หน่อยครับ