Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, Anupam
Consolidate/Merge Data in Multiple Files
I have two spreadsheets - both are lists of items with a tag number, serial number, item description, and comments (among other categories). On one of the spreadsheets, the comments column is completed but it is empty in the other spreadsheet. How can I add the comments from the spreadsheet that has them to the one that doesn't, based on what the tag number of each item is? Both spreadsheets are in a different order and some of the inventory items we have on one list do not match the other list, either because they are new inventory items or they were removed from inventory.
Power Query açılırken “Beklenmeyen bir sorunla karşılaşıldı” hatası (Windows 11 Pro & Office 365)
Merhaba, Bilgisayarımda Excel’de Power Query’i açmaya çalıştığımda “Beklenmeyen bir sorunla karşılaşıldı” hatası alıyorum. Aynı Microsoft hesabı ile giriş yaptığım diğer bilgisayarda Power Query sorunsuz çalışıyor, ancak bu cihazda hiçbir Excel dosyasında çalışmıyor. Denediğim adımlar: WebView2 Runtime kaldırılıp yeniden kuruldu Office onarım işlemi yapıldı Office tamamen kaldırılıp yeniden yüklendi Eklentiler devre dışı bırakıldı Windows ve Office güncellemeleri kontrol edildi Sistem Bilgileri: Windows sürümü: Windows 11 Pro 24H2 (Derleme 26100.4946) Office sürümü: Microsoft® Excel® Microsoft 365 için MSO (Sürüm 2507 Derleme 16.0.19029.20136) Mimari: x64 Sorunu nasıl çözebileceğim konusunda destek rica ederim. Teşekkürler.Downloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 hyperlinks, it's difficult to download each file one-by-one. Thanks in Advance, Br, AnupamBest method to find variances between checkbook deposits and GL deposit transactions
I'm looking for a way to find variances between checkbook deposits and General Ledger deposit transactions. Single checkbook deposits post to the GL as multiple entries (deposits are exported to the GL from a different platform). For example, a single deposit of $10,000 in the checkbook may actually be 5 checks of $2000 each, which post to the GL individually. This wouldn't be an issue except there are often over 3000 individual GL entries and 1000+ checkbook deposits in a given month. I need to determine which groups of GL entries equal each checkbook deposit in order to find the variance. Below is a very simplified version of what I'm looking at. I have tried subtotaling by date, but this doesn't work well, because each checkbook deposit can send entries to the GL with multiple check dates. I have considered Solver, but this problem seems too complicated for that method. Is there a way to do this in Excel, or do I need something more sophisticated? I am an advanced Excel user, but the answer to my problem has eluded me, so far. Thanks for your help.
Excel at 40 Week 1: Days 1–3
Celebrating 40 years of Excel in finance, analytics, and beyond On September 30, 1985, Excel launched on the Apple Macintosh. It replaced paper ledgers, VisiCalc, and Lotus 1-2-3 — and changed finance forever. From macros to Power Query, from PivotTables to Python, Excel has evolved into a powerhouse for financial modeling, auditing, and analytics. This 40-day series shares: ✅ 40 lessons from 40 years of Excel in finance ✅ Real-world use cases with Power BI and Microsoft Fabric ✅ Tips for mastering Excel’s most powerful formulas ✅ My journey as a finance analyst using Excel daily Day 1 — A Finance Legacy Begins 📅 From 1985 to 2025: A visual timeline of Excel’s evolution. Revisit the journey from the first release on the Macintosh to today’s AI-powered, cloud-connected version. Day 2 — Highlight Past Event Dates Automatically 🏅 Excel Tip: Highlight rows automatically when the date is 3 or 6 months old — no VBA required. Formulas used: 3 months → =AND(ISNUMBER($A2), $A2 < TODAY() - 90) 6 months → =AND(ISNUMBER($A2), $A2 < EDATE(TODAY(), -6)) ✅ Apply through Conditional Formatting to keep outdated entries visible without manual updates. 🔗 https://lnkd.in/dVS_DfdB Day 3 — The Evolution of Scale From 4 million cells in 1985 to over 17 billion today, Excel has grown into a data titan. This carousel highlights major milestones and its transformation into a programmable, AI-powered canvas. 💡 From finance models to fantasy football, Excel powers it all. 📌 Satya Nadella on Excel: “Excel formulas, the world’s most popular programming language, is now Turing-complete.” https://lnkd.in/dyex2ymK “Excel with Python is like GitHub with Copilot.” https://lnkd.in/dti5WfsQ 🔗 https://lnkd.in/dp58hDnP Follow the Series 📅 New lessons every week — follow along as we count down to all 40 lessons. #ExcelAt40 #MicrosoftExcel #ExcelTips #MicrosoftFabric #PowerBI #ExcelForFinance #FinancialModeling #AuditAutomation
Power BI DAX measurements
Hello Power BI users. I am trying to create a measurement that gives me the top 10 providers experiencing patient's leaving against staff advice (ASA). The date that I am trying to create this measure lives in two separate tables from two different sources. I've connected these two tables using a date table to connect the two tables. In the ASA_Ali_1 table there are multiple programs with dates listed within each row. These dates include program capacity which will need to be used in the calculation. (of note, the ASA_Ali_1 table does not contain case by case basis information but a summation of ASAs that have occurred for each date corresponding to a specific program). In the CLEAN_ASA table, contains case by case i.e., client leaving ASA and the provider that was working with said client at the time of their departure. I need to use the program capacity to generate a relative number of ASAs of a specific provider (contained in CLEAN_ASA) against the average program capacity (contained in ASA_Ali_1). I would like the output to show me the top 10 providers experiencing ASAs for the most recent month. Here is an image of the two data sources being used so you can get an idea of the structure. To summarize, my outputs columns in report view should show the provider, the number of ASAs they have experienced in the most recent month, the number of ASAs in the most recent month, and the percentage of ASAs relative to that program that provider was working in relative to their respective program's capacity for the most recent month. (please note that the providers program they are assigned to work [within the CLEAN_ASA table] in is titled , "Housing location," and in Ali_ASA_1 this is identified as "Program"). Please let me know if I can create DAX measurements within both tables to generate this output. Any help would be greatly appreciated 🙂PowerQuery tranforming date from different locale stopped working?
I sometimes have to import CSV files from the Philippines, which contain date/time values with a M/DD/YYYY format. I'm not in the Philippines or US, so my default date format is D/MM/YYYY. Just opening the CSV file in Excel would result in errors because Excel would mix up the month and day values. The solution used to be to use Data->Get Data->From Text/CSV in excel, which would open the file in PowerQuery. I could then select the datetime column, right-click and choose Change Type->Using Locale... and select Date/Time and "English United States" and then import the data. This used to work, but today it has stopped working: For example, in this file the first line of data contains a date/time in 13 Jan 2025. Here's the raw data in a text file: However, when I follow the above steps, this date time now just come out as "Error" in PQ: If I import this into Excel, the cells where the day is greater than 12 are blank, and in the others the day and month are still reversed. Is this a bug, or am I doing something wrong?
