Forum Widgets
Latest Discussions
How to format a date (week day) as Japanese, the the English version of Excel ?
Hi, I use the last Excel build of Mcrosoft 365 for Mac (presently Version 16.95 (25021621)), on the last version of macOS (presently 15.3.1) I need to format dates the Japanese way, but using the English version of Excel. More exactly, I need to format dates to that they are displayed in Japanese whatever language being used for Excel UI. I personally use the English UI of Excel, but I need to format dates as (or instance for Wednesday January first, 2025 : 2025年01月01日（水） If I choose yyyy"年"mm"月"dd"日（"aaa"）" then I get: 2025年01月01日（Wed）, which I don't want. I want the week day to be in Japanese! Is there a specific code to do this, independently from the UI language? I couldn't get any code that matches what I want, on the Microsoft Excel support page. Many thanks in advance for any help
Complicated data analys
Enkel Avslutande Heder k2 b2 n2 k1 b1 n1 Ö k3 b3 n3 k9 b9 n9 S k4 b4 n4 V k5 b5 n5 N k6 b6 n6 W k7 b7 n7 G k8 b8 n8 R When any of these show up in my tabel hand 1 pon kan result b2 b1 ö I want a numerick value to show up under result depending on what show upp where the number will be difrent any sugestions on how to do this?
Limitar un filtro de escala de tiempo
Hola, Tengo una base de datos enorme que incluye fechas que van desde el 1 de enero 2024 hasta el 31 de enero 2024. Cuando establezco un filtro de escala de tiempo me aparece la selección para el año 2024 y la posibilidad de seleccionar datos del 2025, a pesar de que en mi base de datos no hay ninguna fecha vinculada al 2025. Qué puedo hacer para ajustar la escala a 1 año (2024) o periodo vinculado a mis datos? Gracias
Dynamic data validation based on another column in table
I'm trying to get the data validation (values from another table) dynamic, in a table and based on the value in another column. I manage to get all values from my other table in data validation using =INDIRECT("TableName[ColumnName]"). But I like to filter the values by the selection in the target table. I've asked ChatGPT, but it only leads me in circles - so now I hope for you super users in here! 😏
Office Scripts Custom Sort Failing During Automation
I am attempting to use office scripts within a OneDrive Excel document within Microsoft Teams to run a custom sort. Using the "Record Action" feature, I simply attempted to sort the range H3:J28 via the Timestamp or the H column. When running the custom sort manually, I get the below result, no errors. When I run the same action using the recorded Script, for some reason the values within the I and the J columns are swapped. Is there a way to avoid this? The relevant script is listed below. function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Custom sort on range range H3:J128 on selectedSheet selectedSheet.getRange("H3:J28").getSort().apply([{key: 0, ascending: true}], false, true, ExcelScript.SortOrientation.columns); }
About Combining Tables in Mutiple Sheets
Hello, I would like to combine all 3 tables in tabs "2024 12", "2025 01" and "2025 02" into CASH REPORT tab. I want to link the following columns in "2024 12", "2025 01" and "2025 02" to CASH REPORT's table A/C NO., EFFECTIVE DATE, CURRENCY, DEBIT/CREDIT, DESCRIPTION, EXPENDED DESCRIPTION, AMOUNT Please see the attached sample spreadsheet. Is there a better way than copying and pasting the columns manually? Thanks.Excel formulas break (#REF error) when source workbooks aren't open
Hello Excel Experts, I'm facing an issue with an Excel file containing multiple formulas that reference three other Excel workbooks. All these workbooks are stored in the same folder on my OneDrive cloud. The problem is that when I open only the main workbook, the formulas referencing data from the other three files break and display a "#REF!" error, making the file unusable. However, if I also open those three source Excel workbooks simultaneously, the formulas automatically restore and work perfectly again. Unfortunately, opening all workbooks each time isn't feasible, as I share this main workbook with colleagues who have access only to this specific file and not the other three source files. As a result, the formulas never work correctly for them. How can I solve this issue so that formulas referencing external workbooks stored in OneDrive work properly without needing the referenced workbooks to be open simultaneously? Thanks in advance for your help!
