Search results

Hi, Please see the attached file if it helps for you in your answer sheet

Respected All, I need a formula Help that can help me to Multiply the value mentioned post "'-" Sign in first Column (Separate Heading) with the Order Qty I have atttached the excel file for your kind Separate Order Qty Expected Result 1211332-2|1211088-2|1211007-3 2...

You can also try this one complete the formula by pressing CTRL_SHIFT+ENT =IF(ISBLANK(A1),"",INDEX($A$1:$A$10,MATCH(SMALL(1*MID($A$1:$A$10,2,FIND("-",$A$1:$A$10)-2),ROW(A1)),1*MID($A$1:$A$10,2,FIND("-",$A$1:$A$10)-2),0))) R6-1.F R1-1.A 6 R1-1.A R7-1.G R2-1.B 7 R2-1.B R3-1.C R3-1.C 3...

Dear Juniad, thanks for your effort, but couldn't reach to the required result i want the formula that generate the same sequence number until the sum value <=20 and then next sequence number should change and remain same till sum value reach <=20 and so on..

Respected All, I need a Formula that can allow me to generate the sequence number against the Qty if sum of the qty <=20 i had tried using =CEILING(SUM(A$2:A2),20)/20 formula but couldn't reach to the required result please help and guide me for the solution Qty Desire Sequence Number|...

Thank you so much Shrivallabha & Peter Sir I am getting the same result which is required to me based on your advised Formula regards Naresh

Respected Bosco Sir, Sorry for Late Reply and thank you so much for giving your time to solve my query your Suggested formula giving me the same result which was required to me but I have to scratch my head a lot to understand thank you so much once again sir regards Naresh

Respected All, I Have a Excel sheet of Pick list Order Details which consist the Details of TO number, Article and respective Qty against To and Article number Based on the Excel or Pick list my assign people go and get the article and Qty and keep it one carton Now I want a formula that can...

Dear Lasantha, I hope attached sheet will help you regards Naresh

Try this one... =SUMIFS($L$2:$L$15,$A$2:$A$15,B$27,$M$2:$M$15,$A28) and change the format to [h]:mm:ss by going to custom format thru CTRL+1 your excel sheet is attached for your reference regards Naresh

Dear Arjun, Pls Put the below formula in your Cell B3 and see if it works for you =A3/(1+$C$1) regards Naresh

if there is a space before your desire result REPLACE(D4,1,FIND(" ",D4)-1,"") regards Naresh

Dear Sir, Sorry for Late Reply and thanks for effort and support I have almost got the result except the Count of Top3 and Bottom 3 article is more than 3 times which needs to be removed regards Naresh

Respected all, I need a formula that can allow me to get the Top 3 and Bottom 3 article list along with their Qty on store+category level Condition are as follow:- pls do not consider Zero sale while getting Top3/Bottom3 article list If the count of store+Cat combination is less than 3 than...

Dear Bosco Sir, Thank you so much.. regards Naresh

Dear Sir, I have gone thoroughly to check the data which is available with me and works the same the way I wanted.. there is no changes in the the result anywhere thanks once again for sharing the second formula which is much easier to me to understand regards Naresh

Dear Sir, thanks once again I do check and come back to you if any issue arrives to me regards Naresh

Dear Sir, Thank you so Much Sir for your time and effort It works Perfectly the way I wanted.. regards Naresh

Respected All, I Need a formula that can allow me to get the count of Immediate Number Only Here is the example for your reference thanks for your help.. Size Location Alias Article no DESC Cat 34 36 38 40 42 44 46 Immediate Count 11 HAZRATGANJ LKU CJNM0970R3BS19FL...

Dear Sir, Thanks for your support and Guidance.. I m getting the expected result based on your given formula only if the "cat" name is unique.. I would urge you to please look my sheet again and help me to come out sorry for not mentioning my criteria in last mail Regards Naresh

Dear Shabbo, you can do it by selecting the column and than go to Text to column ->select delimited->Next->select->"-" in other delimiter->next ->finish

Respected All, I have a data in column with heading name "cat", "Qty TGT" and "Value TGT" for FY 19-20 and I want the category wise YTD Sum of "Qty TGT" and Value "TGT" kinldy find the attached file and expected result for your reference Expected Result...

Hi, PLs try this one in your column no. B =COUNTIF(Raw!$C$2:$C$30,C2) regards Naresh

Hi, Pls write 1st date of the month like A1: 1-oct-2018 and put below formula in B1 to get your result =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))),2)=1)) regards Naresh

Dear Amit, Pls try and see if this works for you =SUMIFS($F$10:$F$20,$E$10:$E$20,">="&C$2,$E$10:$E$20,"<="&C$4) regards Naresh