Search results

Hi: Please find the attached. Thanks

Hi: 1 means true. Thanks

Hi: You can use array formulas as well, there are different ways to skin a cat. However, the array formula you had used was wrong, search the net for index array formula to get the right syntax. Thanks

Hi: Not sure how your data sits..., the easiest way is to pull a pivot table. Thanks

Hi: Formula in yellow column. Note: Not an array formula. Thanks

Hi: This is a basic level VBA, there are hundreds of solutions available on various forums for this. I did not learn excel or VBA in one day, I don't even have an IT background unless you try to figure out solutions on your own you are not going to learn. I am talking from experience. Thanks

Hi: This is a simple if condition please give a search in Google and find a solution. After posting around 94 messages here I would expect you to at least try to find a solution before blankly asking here only because its a free service. Thanks

Hi Use the following formatting as custom format +?#,###,###,###.0;-?#,###,###,###.00 in N8 Thanks

Hi: May be you want to read through the following. https://trumpexcel.com/scenario-manager-in-excel/ Thanks

Hi: Here you go, Thanks

Hi: Find the attached. Thanks

Hi: Just remove the data validation , the macro will still work. Thanks

Hi: May be something like this? =LOOKUP(MID(M2,SEARCH("-",M2)+1,LEN(M2)-SEARCH("Days",M2))*1,$T$1:$T$5,$U$1:$U$5) Thanks

May be this? Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False With Sheet1 On Error Resume Next .ShowAllData i& = .Cells(Rows.Count, 1).End(xlUp).Row If Not Intersect(ActiveCell, .Range("A2:A2")) Is Nothing Then If .[A2] <>...

Another method Sub blah() With Sheet1 i& = .Cells(Rows.Count, 1).End(xlUp).Row .[J2].Resize(i - 1).Formula = "=IF(H2=""NO"",""NO Part Reqd"",""Yes part Reqd"")" End With End Sub Thanks

Hi: Can't you pull a pivot for this? Thanks

Hi: Is this what you are looking for? Thanks

Hi: A Non-Array solution. =IF(SUM(COUNTIF($B2:$F2,{"green","bird"}),$B2:$F2)>=1,"Valid","") Thanks

Hi: Find the attached. Thanks

Hi: Pull a pivot. Thanks

Hi: Something like this? = if (Text.Contains("CAR",'Allocation dump required MP state'[ASSET_DESC]) then "CV" else "MC") Thanks

Hi: May be something like this =SUBSTITUTE(D3,CHAR(160),,1) Thanks

Hi: Its difficult to fully comprehend what your file look like without a sample. Have you tried advanced filter options? https://www.techrepublic.com/blog/microsoft-office/how-to-use-and-and-or-operators-with-excels-advanced-filter/ Thanks

Hi: This macro version will automatically adjust the axis when you make the changes to dates. Thanks

Hi: Find the attached. I have customised the axis Thanks