Forum

Hi Jessica Stewart Many thanks for your formula, what i expect i got it the same.

Hi Revathi What i understand i have updated in highlighted

Hello Jessica Is there is any formula we can use in direct total cell & with out we can use Helper(=IF(AND(SUMPRODUCT(--($A$3:A10=A10))>1,S...

Hi Jessica I got my answer... thank you so much for giving precious time for me. Thanks/Saliha

Hi Anders We need 1800prs subtotal here F63 cell as per , bcoz we need to add single pairs for based on (OEF+SAP#) OEF + Sap# 35200+99317 = ...

Hi Lionel thanks for your suggestion, im very sorry for not clearly mentioned in above message, but i need subtotal in table area which is highligh...

Hi Riny i have updated your formula working file but i need qty updation based on first of date condition Saliha

Hi Riny / Jessica Thanks for you help, i have achieve 80% of my work based on your allocated formula option, possible to add delivery date wise, wh...

Hi Jessica Stewart Thanks for your help but there is one more step is missing delivery date, bcoz we need to update qty date wise with S.L. on...

Hi Catalin Bombea there is any formula to update in excel with out VB code Thanks /Saliha