Search results

Hi: Pretty easy using power query. find the attached. Thanks

Hi: May be this? Using power query. Thanks

Hi: Using group index. Thanks

Hi: I have written a function in module 1 ( it's a standard set of codes nothing fancy ) of the work book, copy that as well to the other workbook for the formula work. Thanks

Hi: May be this? I have used power query to manipulate the data in the format you need. Thanks

Hi: May be this? Formula in the coloured cells. Thanks

Hi: I am not still clear, I believe the current formula is doing what you have asked for , April is month 1 for 131, since there is a number greater than 0 in column H the formula makes the month to 2 in this instance, I am adding column R to this to happen. However, if the monthly increment...

Well, the criteria you have given in spread sheet and the criteria you are giving now id totally different. Clearly explain the logic behind what you are looking for to get a solution.

Hi: May be this? Thanks

Hi: This will be a good read to understand if conditions better. https://www.contextures.com/xlfunctions06_excel-if-function.html Thanks

Hi: May be this?=IF(ISNUMBER($C2),"Closed",IF(B2="Continuation",$B2,"Open")) Thanks

Hi: I am not sure what kind of analysis you are looking for. I have transformed your raw data using power query and pulled a pivot to summarise the data(sheet2) Thanks

Hi: Use the formula =SUMPRODUCT(($A2=Sheet2!$A$2:$A$15)*(C$1=Sheet2!$R$1:$Z$1),Sheet2!$R$2:$Z$15) Thanks

Hi: One way to do this is to merge the two tables using a unique field and pull the columns needed into a new output table. Note: Create the merge table as new merge table and populate the output in this table. Thanks

Hi: May be this? Thanks

Hi: May be this function Function colour(rng As Range) As String Dim r$ c$ = rng.Text For i& = 1 To VBA.Len(c) If rng.Characters(i, 1).Font.Color = 4172854 Then r = r & VBA.Mid(c, i, 1) Next colour = Trim(Left(r, 1)) End Function Thanks

Hi: If you know power query this is very easy to achieve , there is any need for vba codes. https://support.office.com/en-us/article/combine-data-from-multiple-data-sources-power-query-70cfe661-5a2a-4d9d-a4fe-586cc7878c7d Thanks

Hi: Use the following code Sub blah() With Sheet1 On Error Resume Next .ShowAllData i& = .Cells(Rows.Count, "A").End(xlUp).Row j& = Sheet3.Cells(Rows.Count, "A").End(xlUp).Row k& = Sheet4.Cells(Rows.Count, "A").End(xlUp).Row l& = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row Sheet3.Range("A2:P"...

Hi: I have modified the code, you can now add how many ever charts you want to this particular worksheet. Thanks

Hi: How many graphs needed to be formatted? is the no: of graphs going to be static? Thanks

Hi: You are getting the chart formatted using vba code , you will have to write codes for the new charts if you want to create to get the same effect. Thanks

Hi: Find the attached. Thanks Nebu

Hi: I have put a vba code to achieve this and have changed your lay out a bit to filter for months. Thanks

Hi: May be this? Thanks

Hi: May be this? I have to use a helper column to achieve this. Thanks