Forum Widgets
Latest Discussions
HELP! Consolidating data in spreadsheet without data loss
I have a dataset that I'm trying to consolidate into unique records without losing any data. Each observation has an SSID number, and there are duplicate entries in the SSID number column. I don't want to de-dupe the records using Excel's de-duplicate, because there is information across multiple rows/columns that I would like to consolidate. Here's an example (with fake IDs to preserve confidential information): My duplicate ID is highlighted with conditional formatting. I'd like one observation for student #1234, but that preserved both the grade in Column D, and the 'yes' in Column C that appears in the second row for student #1234. Using Excel's native de-duplicate or consolidate data functions means I lose either the grade in column D or the yes in column C. Any way to do this?4Views0likes1CommentSpreadsheet Compare Highlight Function
Hello I would like to know if rows can be highlighted in the compared files using the Spreadsheet Compare program. I want the rows changed, rows deleted and the rows with entered values changed highlighted in different colors respectively on the compared sheets by the Spreadsheet Compare program itself. Is it possible? Basically, the Spreadsheet Compare program takes in two spreadsheets - Old Data and New Data. I want the added rows detected in the new data sheet to be highlighted green, the changed rows should be highlighted yellow in the new data sheet and the deleted rows should be highlighted red in the old data sheet. I would like to know if there's any way to accomplish this using Spreadsheet Compare or any external method. I'd greatly appreciate any help! Thanks!4Views0likes0CommentsSearching 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 17, 2025Brass Contributor112Views0likes8CommentsExcel Javascript API: Question about Bindings
Hello, I've got a question about using Bindings in the Excel/Office Javascript API, especially regarding listening to binding updates. There are ways to listen to updates to specific bindings using https://learn.microsoft.com/en-us/javascript/api/excel/excel.binding?view=excel-js-preview#excel-excel-binding-ondatachanged-member But what I'm looking for is listening for updates on newly created bindings. This is especially relevant in the Excel Online / OneDrive sync. If one instance of Excel creates a binding, I want all other instances to receive an update about it. Something like this: await Excel.run(async context => { context.workbook.bindings.onAdded.add((...) => {...}); });JorikJan 17, 2025Occasional Reader6Views0likes0CommentsCascading Data Validation 3 level dropdown list with reoccurring text
Good day, I want to make a 3 level cascading dropdown list but the 3d level is not working. My idea is to make a budget tracker from 2 banks (Level 1) from which each bank has 3 accounts (Level 2) and each account has a different currency (Level 3). The problem arises when different accounts have the same currency. The system does not seem to be able to read it and returns a blank dropdown. Is there a way around it? attached is the link to the file: Excel questions Feel free to reach out if there are any questions. Thank you in advancedRiazz027Jan 17, 2025Copper Contributor32Views0likes6CommentsConditional formatting? highlight a cell based on current time
Working on an hourly To-Do list. I have a column (H) with the listed hour (on the Hr) starting with 5am all the way until 11pm. For Example: 6:00 AM 7:00 AM 8:00 AM 9:00 AM The ask: I would like the 7:00 AM cell be highlighted when the current time is between 7-7:59 AM. Then the next cell once it hits between 8 and 8:59 and so on. Thank you and let me know what you think?SolvedandermanrnJan 17, 2025Copper Contributor31KViews0likes22Comments
Resources
Tags
- Excel42,016 Topics
- Formulas and Functions24,354 Topics
- Macros and VBA6,328 Topics
- office 3655,900 Topics
- Excel on Mac2,606 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,868 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics