Search results

I have asked the same question in this forum but moderator may blocked it without any notification, but showing message of "moderator edited" on it. Why the moderator blocked my question without any reason?. If there was something wrong? So I am asking the same question again here. As per the...

Good Day Sir, Is the above given information is clear?. Moderator edit : thread closed as a duplicate thread was created …

Hi Sir, Good Day Thank you for your reply. In the attached workbook Data2 sheet is my data entry sheet. In Data2 sheet L Column there is mentioned 2 types of entries 1. Receipt and second Replacement. I would like to sort out each parties Receipt and their replacement with correct item from...

how to find a entry match against it and make a report like a the attached sheet Sheet1. In the Sheet1 Report row 13th and 14th row received 3 star item and given 4 star item. How to do that. Can we do with VBA or Formula. Can someone help me to solve this.

I got the formula =SUMIFS($I$4:$I$441,$E$4:$E$441,$N$28,$F$4:$F$441,M29,$A$4:$A$441,">="&$P$23,$A$4:$A$441,"<="&$P$24) If any other way to write this formula. Please tell thanks

Hai How to use If sumifs formula to calculate between period of date. My worksheet A4:441 has date column. I want combine the below given sumifs formula with the period of date 01/05/2019 to 31/07/2019. The period of date which need to calculate mentioned in H1 and H2. 01/05/19 31/07/19...

thanks for all

how to use formula for summing the follow with the word that contain 15w b22 in the cells Item Qty Sum Total 15w b22 cdl ball 15 15w b22 15w b22 ww 25 15w b22 ww re 15 15w b22 prpk 10 15w b22 4star 8 thanks

Thank you for your help and time you have spend for me. May God bless you. Happy Vacation.

Please check the date in the blank cells

why the date coming 30-12-2137 in the above report. Somebody can tell me?

Sorry Sir You miss understood me. I did not put any condition I just try to show my requirement. Your help is just a favour for me. If you would like to help then help me. If any of my post make you feel bad, I am so sorry. Pls. find the report without formula

Sir Good Day If you get the time please check the following. Thank you for your reply effort and help for me. Sir I think your these formula working good in the unsorted file. In the sorted file report showing error in the result. Sir I have sorted my Original Data. So the report showing...

Sir one help can you do for me if you have time. Can we use the formula without index small as in the attached file. Without Index Small how we can use it...

Thank you sir , Now its working good. Thank you so much for your kind help. I spend lots of time try to correct the formula, Warm regards.

Sir Good Day As per your report jack999-navic-42129-7 it was good. There was only one error as follows There was only one error that Sum the Sales figure with Scheme if invoice number or Ch.number are same (eg.Ch.9898). * Report2 Sheet Green Highlighted item Other part of the Report and...

Now also I am getting error with my original Data. Really I am tired of. In the first line #N/A value not found. I don't no why ? ITEM NAME LED ADORE 9W B22 CDL 4 STAR LAMP Op. Balance 0 Date Item Name Invoice No. Description Inward Outward Balance #N/A TRIM CLIP ON...

Sir Please look into the matter

Sir not in the balance column. It is in the inward outward column. Sir please see the attached file.

Sir Good Day Thank you for Reply Sir one request, I have sorted my original Data2 sheet's Invoice Date as (A to Z) ascending order so how to change this formula now. Sir please help. Sorry for the trouble. I really did not think that will make trouble.

Sir Good Day. Can you please help me for the following Sir yesterday I noticed that a small error in the report (in the report2 green highlighted items in the attached file). Its summing sales with scheme while invoice number and item is same.

Good Sir. Thank you so much.

Sir, Thank you for you Reply. Sir, when we delete or remove one row (suppose unnecessary record) from the Data2 sheet, all the data in the report1 go to disappeared. What is the reason. How can we overcome this problem. If we remove one unnecessary record form the data2 then all the report...