Search results

Hi: Find the attached. Thanks

Hi: I have modified the code accordingly. Thanks

Hi: Have modified the code. Thanks

Hi: The following Macro Sub blah() Dim xlSort As XlSortOrder i& = Me.Cells(Rows.Count, "A").End(xlUp).Row With Sheet1 .Range("B2:AC" & i).Sort Key1:=.Range("B2"), _ Order1:=xlAscending, Key2:=.Range("J2"), Order2:=xlAscending, Key3:=.Range("K2"), _ Order3:=xlAscending...

Hi: Is this what you are looking for? Thanks

Hi: Your explanation and your spreadsheet is not matching, could you be more specific on this? Thanks

Hi: Not completely sure what you want here... refer to the yellow column in that attached. Note: - Array formula , execute by pressing Control+Shift+Enter - I had constructed the formula in a different column, since you have circular references in your formulas, you may want to rethink the...

Hi: If your incoming ticket column will not take any other format than what you have in your attached file, you can use the following formula. =IF(A2="","",IF(ISNUMBER(VALUE(A2))=TRUE,"ABCDEF-"&A2,"ABCDEF-"&RIGHT(A2,LEN(A2)-SEARCH("-",A2)))) Thanks

Hi: May be as attached. Thanks

Hi: I have taken the easy way here, the attached macro will clear all the contents in In-house and Discharge tab and will copy and paste the contents from Master List based on the filters applied. Thanks

Hi: if you have logic to identify the new records , I can translate that into VBA code. You necessarily do not need to know VBA. Thanks

Hi: This Macro will filter for Discharge & In-house from Mater list , copy and move to respective tabs on clicking the button move. However, I have not incorporated the filter for new records as I am not sure about the criteria to apply there. Sub TestDC() Application.ScreenUpdating = False...

Hi: Refer the following link for a solution https://www.myonlinetraininghub.com/excel-3d-sumif-across-multiple-worksheets Thanks

Hi: May be this macro? Thanks

Hi: Using Power Query, it is easily achievable, find the attached. Thanks

Hi: May be a pivot? Thanks

Hi: May be this? Array formula: =IFERROR(INDEX(B2:G2,MATCH(I1&1,$B$1:$G$1&$B$12:$G$12,0)),"") Execute by pressing Control+Shift+Enter Thanks

Hi: May be the code as below.. Thanks

Hi: One way you can do this is using "R-Code" in Power BI, here is a chart I created in reverse X axis using "ggplot". It is bit advanced power BI , but integrating R or Python with power BI will give very powerful custom visualisations. Thanks

Hi: I guess the formula should be =COUNTIF(INDIRECT("A2:A"&B1),1) Thanks

Hi: Find the attached. Thanks

Hi: Formula in Yellow column. Thanks

Hi: You can achieve a similar format using power query.. Thanks

Hi: Its really easy to do this using power query, find the attached. Thanks

Hi: Well, your one liner responses are not making any sense and have not given any peripheral information "I need help on edit macro. File is attached" What does that even mean? Remember this is a free service so respect the individuals giving you the solution. Thanks