Forum Widgets
Latest Discussions
Filtering Out Rows With Specific Text When Filtering With Multiple Criteria
I have a workbook to find duplicates in content that is housed on our site. This workbook has different worksheets that are combined into one using Power Query and each instance is tracked using an index key to specify what each is a duplicate of and of which type. From there, I used the Power Query output table name (Duplicates) to create a dashboard, that has search boxes to help narrow down the list so it's easier to find the related duplicates. I'm using the FILTER function to filter the table according to the indexes at the top and ignoring the second, third, and fourth indexes if the search fields are blank. I'm sure there's a better way to do that but it was the only way I could get it to work. =FILTER(Duplicates,ISNUMBER(SEARCH(B1,Duplicates[Index]))+IF(B2<>"",ISNUMBER(SEARCH(B2,Duplicates[Index])))+IF(B3<>"",ISNUMBER(SEARCH(B3,Duplicates[Index]))),IF(B4<>"",ISNUMBER(SEARCH(B4,Duplicates[Index])))) There is a Notes column added at the end of the table that I am trying to target so any items that are marked as "Done" are not in this list. I've tried amending the FILTER function with NOT(ISNUMBER(SEARCH("Done", Duplicates[Notes]))) and using an * or + but it just causes a VALUE error. I have also tried adding ISNUMBER(SEARCH("", Duplicates[Notes])) with an * or + as well. Due to the nature of this content, I cannot share the source file so if I can provide any other clarifying information, please let me know.
Need Formula Help
I have a table of phone activity for agents that I need to create charts from. I have another table for a chart to extract Log In and Log Out times for each day. I don't know what formula to use that will take into account the different dates, and also the fact that agents might log in multiple times a day. What is a formula I can use to pull the first sign in time of each day? I tried SUMPRODUCT but it added the times together, I just need to know the initial log in and log out time for each day. Can I use multiple criteria on VLOOKUP?
VBA requirement
Hello, I have requirement in VBA. When I click on Sheet1 CellA3 then I should redirect to Sheet2 and display the Sheet1 clicked cell value and its adjacent cell value as well CellB3. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim searchValue As Variant Dim foundCell As Range Dim targetSheet As Worksheet If Target.Worksheet.Name = "Sheet2" Then If Not Intersect(Target, Target.Worksheet.Columns("A")) Is Nothing Then searchValue = Target.Value Set targetSheet = ThisWorkbook.Worksheets("Sheet1") Set foundCell = targetSheet.Columns("A").Find(What:=searchValue, LookIn:=xlValues, LookAt:=xlWhole) If Not foundCell Is Nothing Then Target.Worksheet.Range("B1").Value = foundCell.Offset(0, 1).Value Else Target.Worksheet.Range("B1").Value = "No Match Found" End If End If End If
need a formula
I have data in a cell that forms two columns: "|sku#1 | header: data data data,header2: data2 data2 data2,header3: data3 data3 data3,header4: data4 data4 data4|" it looks like this on the webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 ------------------------------------------------------- to replicate this on the new webpage i need to upload it to a different server in a different format. Each header has to become a column Attribute with the data in the rows of that column | sku | header: | header:2 | header:3 | header:4 | | sku#1|data data data| data2 data2 data2 | data3 data3 data3 | data4 data4 data4 | It will look the same on the new webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 I have fought all night with the Microsoft formatting throwing errors so i have simplified this as much as i can. i am ok with VBA but do not understand Piviot tables so please do not suggest them. I would like a simple excel formula(s) so i can build into into my sheet but i do not think it possible even with multiple steps. i will look at everything - thanks in advance - ask questions if you need real examples or clarification. Make it so each header becomes an attribute / column header with the data below it in the column aligned with the corresponding sku
