Forum Widgets
Latest Discussions
Searching column cells for similar text values and summarising in another column
Hi Experts I hope you can help here. To be honest without Macros not sure this is possible with formulas? I attach an example workbook with my desired results from the data. Basically we have a support ticket system for users and can export the "summary" or "titles" for each ticket. We want to have a formula to analyse the column with all the ticket titles and produce a list of common similar themed topics, and the number of deemed occurrences. Now I know this can be done either looking for an exact text word match but the difficulty comes where I am hoping excel can attempt to categorise similar patterns of words / phrases / text. Any solution via formula or am I expecting too much? Thank you for your help!Solvedmatt0020190Jan 14, 2025Brass Contributor90Views0likes7CommentsNeed 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?SchledornJan 13, 2025Copper Contributor92Views0likes2CommentsStamp Duty Calculation
Hello, I have a SUMPRODUCT formula to calculate stamp duty in the UK below where F2 = the purchase price of a property. =SUMPRODUCT(--(F2>{0;250000;925000;1500000}),(F2-{0;250000;925000;1500000}), {0.03;0.05;0.05;0.02}) I want to edit this formula so that if F2 is less than 40000 then the stamp duty = £0 regardless of the above formula. Can anyone assist me please? Thanks, PatSolvedPat_Burrows1970Jan 13, 2025Copper Contributor23KViews0likes7CommentsVBA 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 IfgbavikatiJan 13, 2025Copper Contributor10Views0likes1Commentneed 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 sku7Views0likes1CommentFiltering 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.renee_crozierJan 13, 2025Brass Contributor44Views0likes2Comments- KofC9282Jan 13, 2025Copper Contributor16Views0likes1Comment
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.ArendJan 13, 2025Copper Contributor11Views0likes1Comment
Resources
Tags
- Excel41,972 Topics
- Formulas and Functions24,325 Topics
- Macros and VBA6,323 Topics
- office 3655,894 Topics
- Excel on Mac2,603 Topics
- BI & Data Analysis2,311 Topics
- Excel for web1,865 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,601 Topics