Can any one help me out by framing formula to get the output please
Please upload your file. It's easy for everyone to help you ☺
please translated into Vietnamese to your needs that, hehe, I don't understand what he needs you
I got the solution bro
One part is pending. I'll try share it by translating into Vietnamese
L9=SUMIFS($E$2:$E$9,$D$2:$D$9,">="&$H$2,$D$2:$D$9,"<="&$I$2,$B$2:$B$9,J9,$C$2:$C$9,K9)
$E$
$D$
$H$
$I$
$B$
$C$
M9=AVERAGEIFS($E$2:$E$9,$D$2:$D$9,">="&$H$2,$D$2:$D$9,"<="&$I$2,$B$2:$B$9,J9,$C$2:$C$9,K9)
Your formula in J2 contains "N8" ?? With 1 Unit ID can have 2 name? E.g. Unit ID "AAAA" have 2 name "ZZZZ" and "ZAZA"?
Bro in sheet2 if n 10 is 0 then q10 must be blank
I don't have idea very I have I'm wrong it is requested to go through the link shared
Awaiting for solution's bro
Your formula is only correct with 2 ID. If your have above 2 ID, the formala is incorrect.
Hanged up there
you can use IF(N10=0,"",your old formula)
I don't get?
The output should meet start time to and I'd as well
=IF(N10=0,"",INDEX($B$1:$B$9,MATCH(K10&L10,$G$1:$G$10,0),1)&", "&OFFSET(INDIRECT("B"&MATCH(K10&L10,$G$1:$G$10,0)),1,0))
$G$
I'll try and get back to you soon bro
I'll try it and get back to you soon bro
With AVG column, you can use IFERROR to fix #DIV/0! =IFERROR(AVERAGEIFS($F$2:$F$9,$E$2:$E$9,">="&$I10,$E$2:$E$9,"<="&$J10,$C$2:$C$9,$K10,$D$2:$D$9,$L10),"")
$F$
$I10,$
$2:$
$9,"<="&$
$K10,$
$9,$