Search results

Hi Team, Attached excel sheet , I want to calculate interest on outstanding amount. rate of interest is 18% want to apply on no of days delayed. till date of each month cut off dates I have filled amount received with payments dates ₹ 2,200 14.06.22 ₹ 2,200 14.06.22 ₹ 2,200 14.06.22 ₹ 2,200...

Hi Bob, Thank you so much for your help it worked ,and also liked step by step explanation.:awesome: Thanks mg

Hi Bob, if range b2 Contain Feb-2020,or Mar -2020, then Macro should give error message, Immediate Previous month not available. sorry for cross posting, as I was looking for urgent help on this. Thanks mg

Hi Team, Compare Current month File which is range ("a2") to Range("b2") , b2 should be previous month file of range ("A2), Thanks in advance for your help. A B Current Month File Previous Month File ABC XYZ INDIA PRIVATE LIMITED (Period = May-2020 - May-2020) ABC XYZ INDIA PRIVATE...

Hi Marc, Thanks for looking in my thread, I want something like below, or any other option I am ok with it. I want outer loop in on Cost Center Description which is in Mapping sheet, , inner loop for finding headers as per mapping sheet , and summing those headers. User can change add extra...

Hi Team, I have attached my Macro with Input File, Macro gives correct result. but the code is not dynamic. Need your help in creating Single custom Sumifs Formula , (Criteria ,sumranges and header, parameter should pass from Mapping sheet.) User will update Mapping sheet, According to that...

Hi Team, In a attached Macro and its input file , I am getting correct result however I want to make a code dynamic. In mapping sheet which is beside Macro tab , Colum ABC is a Template, Cost Center Description is standard and Fixed. I copy the template and create new workbook for output...

Hi Mark L, Thanks for your help, to some extent I know advanced filter how it works, But Unable to fix it in my situation. Can you suggest how to apply in my situation , Most of the time I come across this situation. Thanks mg

Hi Team, I am using below code and its giving Correct result. Situation1 Column A, B, C, are my Raw data, Situation1, Column F,G,H Are my filter Criteria List.{Filter In} Situation2, Same situation but exclude Column J Criteria list (Filter Out) Situation2 - Column J,K,L Are my filter...

Hi Team, Need pivot columns header sorting as per Criteria in Column E. Pivot columns should get rearranged as per Criteria list E. Regards, mg

Hi Marc, that didn't clicked, I used =SUMIF($A$2:$A$13,D3,$B$2:$B$13) , it worked. Thanks Regards, mg

Hi Team I have below data and I want to count no of movies made by Actors as per Name in Criteria. expected result is in Colum F & G. Trying to understand how to use collections/dictionary to get the result. Name Movies Made Criteria Name Movies Made Hrithik 21 Hrithik Hrithik 58...

Hi Marc, Your genius. It worked out perfectly. Thanks a ton for all your help. Regards, mg

Hi Alan, Thanks for your help , but I am looking solution in vba I don't have idea of powerQuery yet. Regards, mg

Hi Team, Need your help in VBA seperating Data Datewise. Column B Contains Files Received Dates it will in ascending order I want to see date wise file Received, from Vertically to horizontally. as shown expected output from Column E. Dates are in text when checked with isnumber. Date column...

Hi RahulShewale and AlanSideMan, Thanks a lot for your help on this, I am getting data through server, expected output not possible through pivot hence doing it manually. I will restructure my question , and resend it Thanks Regards, Mallesh

Hi Team, Columns A Contains Trade ID and Columns E Contains Date, My Task is to take only Unique Trade ID in each row from Range(I3) to downward. and update its file name in date wise columns. if repetation of trade ID in any column, dont add extra row in output,But their file name should be...

Hi Team, I am looking for excel formula/VBA Code for my attached data, I want to fill column C and for that I am using vlookup. my actually Data is different just replacated some dummy data. I am getting Result with the below formula, however I have taken the helper column in Mapping sheet...

Hi Team, Need your help in sumproduct formula, Below formula giving correct result. Three Columns and Three Criteria Range("F12").Formula = Evaluate("=SUMPRODUCT(ISNUMBER(MATCH($A$1:$A$100,$E$2:$E$4,0))*ISNUMBER(MATCH($B$1:$B$100,$F$2:$F$4,0))*ISNUMBER((MATCH($C$1:$C$100,$G$2:$G$6,0))))")...

Hi Team, I am using below formula in excel, and getting Correct result, Is there any alternate formula to get the same result here. =SUM(COUNTIFS(H:H,{"North","South"},I:I,{"London";"NY"},$J:$J,"Finished")) Thanks in advance for your help. Regards, mg

Hi Steve Superb !!!! Thanks a lot for your help and your precious time on this -got the answer as expected. Thanks Mallesh

Hi Team, Need your help, how to shorten the code , merging two loops into single loop. In sheet expected output wherein I mentioned expected result. attached code in workbook it works. Thanks for your help in advance !! Thanks. mg

Hi Team, I am comfortable in applying vba-vlookup formula in same workbook.But when the data is in another workbook i face a problem, I am trying to apply vlookup up formula in thisworkbook.sheets(2).range("B2") Mydata is in another workbook. Getting error at vlook up formula. When searched on...

Hello experts !! Column A Consist of trade ID, Column B the person who is worked on those trade, Now my task is reshuffle the work for verification , I have unique values in column E, to be pasted in Column C 3 times, In such a way that - infront of singhams name Singham name doesn't come...

Hi Team, I am new in VBA and this is my first post I want to consolidate daily counts sheets data into mater workbook under respecitive sheets. I have a Daily Count Workbook and which has 6 sheets. say [A,B,C,D,E,F] here my daily task is copying data from sheets [A,B,D,E] and Pasting the...