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?
Spreadsheet 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!
Excel 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((...) => {...}); });
Cascading 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 advanced
