thank you. i just need one condition, if possible, when i put number in result sheet so data check & match 1st Sr no and then number and show number latest count and date .Office 365 Solution
=FILTER(raw!$A$2:$D$8,(raw!$A$2:$A$8=results!A1)*raw!$B$2:$B$8=LARGE(raw!$B$2:$B$8,1))
thanks you for your support, result file attached.Could you provide the manual required result what exactly you want to retrieve.
thank you so much working perfectly.Try,
1] In B3 copied down: =MAX(FILTER(raw!B:B,(raw!A:A=A$1)*(raw!C:C=A3),""))
2] In C3 copied down: =FILTER(raw!D:D,(raw!A:A=A$1)*(raw!B:B=B3)*(raw!C:C=A3),"")
View attachment 83498