Hi,
This formula is applied at B12
=LET(nn,LET(sortedData,SORTBY(INDIRECT(B1&"!A5:R10998"),MATCH(INDIRECT(B1&"!J5:J10998"),Master!C2:C10,0),1,MATCH(INDIRECT(B1&"!A5:A10998"),Master!B1:B13,0),1),FILTER(sortedData,INDEX(sortedData,0,9)="ABC ROSE","")),IF(nn=0,"",nn))
In B1 which is a dropdown it is worksheet name which one can choose and above formula works very fine.
Here,I want to add one condition that if col M12 & below and S12 & below,if it is blank then zero must be exist and rest as above formula does.
All this I require through VBA so the result I can get in value and not in formula.
This formula is applied at B12
=LET(nn,LET(sortedData,SORTBY(INDIRECT(B1&"!A5:R10998"),MATCH(INDIRECT(B1&"!J5:J10998"),Master!C2:C10,0),1,MATCH(INDIRECT(B1&"!A5:A10998"),Master!B1:B13,0),1),FILTER(sortedData,INDEX(sortedData,0,9)="ABC ROSE","")),IF(nn=0,"",nn))
In B1 which is a dropdown it is worksheet name which one can choose and above formula works very fine.
Here,I want to add one condition that if col M12 & below and S12 & below,if it is blank then zero must be exist and rest as above formula does.
All this I require through VBA so the result I can get in value and not in formula.