Forum Widgets
Latest Discussions
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 skuFiltering 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.FILTER problem in Excel 365
I am facing a filter problem. - I have created a table called Table_1. This table is on the tab TABLE In addition, the filter below is on the SEARCH tab =ALS.ERROR(FILTER(Table_1;NOT(ISFOUT(FIND.SPEC(A1;Table_1[Name]&“*”&Table_1[Zip Code]&“*”&Table_1[City] )))); “Nothing found”) Unfortunately, I get a return message ifl I search in a programmed search field for, say, PLACE OF RESIDENCE the message #Overflowing! in Dutch #OVERLOOP! In addition, I cannot center the text in the SEARCH FIELD vertically. For that, all options in the TAB START are all in gray; NOT available to make changes. I don't know now what I am doing wrong. Can you help me? Thanks for any suggestion.
