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 helpchibiberuMar 17, 2025Copper Contributor67Views0likes5CommentsComplicated 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?Ellie_1066Mar 17, 2025Copper Contributor70Views0likes3CommentsLimitar 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? GraciasMarta1Mar 16, 2025Copper Contributor41Views0likes1CommentDynamic 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! 😏SolvedJake71Mar 16, 2025Copper Contributor140Views0likes7CommentsExcel Sort is broken
I have no idea how this problem happened. I have an Excel spreadsheet that's just under 500 lines long. I keep dates and times and hours in it. I enter the data one new week at a time at the top. I occasionally grab a block of a few weeks and copy it to the right and then sort by date to change it from newest first to oldest first. This has always been a no brainer. Very easy to do. Today, it didn't work. Furthermore, trying to reverse sort the previous blocks of data, which I leave hanging around on the right, is no longer working. I went through the update process to see if I somehow missed something. Also, I don't use any add-ins. Again, doing a sort on something which sorted days ago no longer works. Has this broken for anyone else?SolvedJim_T1405Mar 16, 2025Steel Contributor75Views0likes1CommentOffice 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); }SolvedTaurusGear13Mar 15, 2025Copper Contributor94Views0likes3CommentsUsing VLOOKUP over multiple columns
Pardon me if I posted this earlier. I didn't see my questions when I later returned so here it goes again. Using Microsoft 365 personal, Excel on a MacBook. I have a basis understanding what VLOOKUP is doing after countless videos. I have a roster of members (name, address, phone, emails, lodge). I got the VLOOKUP to work with the names, addresses and phone number (Columns C thru G), displaying in a new worksheet perfect. After the phone number column G, there are columns for other things ie $, parking, etc. Then in the last two columns (Q & R) I'd like some more member's information from that previous VLOOKUP. These would be columns 16 and 17. Cut and pasted the first formula. I changed the =VLOOKUP formula to reflect column 16 and 17 and I get the #REF! error message. It's sort of a auto populate problem, there I'd like to avoid typing info in columns Q and R. I'd really like someone to go live with me on this spreadsheet, where I could observe on my screen, if that is possible. Data is all fake. HELPSolvedkwahl1Mar 15, 2025Copper Contributor138Views0likes2CommentsAbout 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.udonloverMar 15, 2025Copper Contributor63Views0likes1CommentExcel 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!fsofiahMar 15, 2025Copper Contributor50Views0likes1Commentneed to create a macro to load images to cells which located in one drive
in column "i" and and column "P" i have linked hyperlink for images. when clicking on command button i need to load images to cells in columns "J" and "Q". can anyone help me to arrange a macroRavinduEBMar 15, 2025Copper Contributor31Views0likes1Comment
Resources
Tags
- excel42,390 Topics
- Formulas and Functions24,579 Topics
- Macros and VBA6,375 Topics
- office 3655,980 Topics
- Excel on Mac2,633 Topics
- BI & Data Analysis2,351 Topics
- Excel for web1,901 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,618 Topics