Recent content by jack999

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...