Forum Widgets
Latest Discussions
Index Match broken after update
I am used to using Index Match to combine information from 2 tables into 1 table, matching based on a unique field, such as invoice number. Excel used to crash frequently, until IS upgraded my Excel to a more recent version. It now rarely crashes, but my formulas are broken. Here is some test data and the formula that USED to work. I am trying to pull the description from the 2nd table to the 1st, using the invoice # to match. I learned to add @ to get rid of the #SPILL! error, so here is the formula with @ added: You can see that it's copied the data for line 3 successfully, but the others don't work. I used this daily on sheets with 100s to 1000s of lines. Manually matching is not an option. I've spent several days troubleshooting and decided it's time to ask for help. I've tried various lookup (vlookup, xlookup) formulas as well, those didn't work. I saw "Index Match Match" but I can't figure it out. Also, why require matching twice when the old formula only required it once? Seems like a downgrade. Thank you in advance for any assistance.
Multiple lookups from Data base information
looking for a method to lookup pallets, the data base has information entered by a form that includes shift and machine dataItemName values PL5 Shift 3rd PL4 Ending Partial Pallet / Paleta Parcial Final 9 PL4 Starting Partial Pallet / Primera Paleta Parcial PL5 Ending Partial Pallet / Paleta Parcial Final 0 PL5 Starting Partial Pallet / Primera Paleta Parcial 0 PL4 Finished Pallets / Paletas Totales 40 PL4 Shift 3rd my summary sheet is looking to match the date (easy) but need to include the lookup value of say PL5 shift value of 3rd, and provide the PL5 ending and starting partial pallets in different cells. I have been able to use xlookup to get all the other data needed but not the shift and pallet information. example xlookup(date&shift&line,table[date]& (this is where I run into an issue) any assistance is greatly appreciated.
access to bookings
What does this message mean on microsoft booking, ive been trying to see my booking registry but i keep seeing this message, sometimes the massage varies when i try to access the app : Detailed message displayed: UTC Date: 2025-03-11T14:14:30.266Z Client Id: F6F199305D9541EDA2A53EE57C90EDB8 Session Id: 8009806d-b6f3-40b9-9ddd-0ef7ba2b900f Client Version: 20250310070 BootResult: network Back Filled Errors: Unhandled Rejection: Error: [object Object]:undefined|Unhandled Rejection: Error: [object Object]:undefined|undefined:undefined|undefined:undefined err: Error: [object Object] esrc: StartupData et: ServerError estack: Error: [object Object] at https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.47106.6187e72c.js:1:71227 at async S (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:3108) at async https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:2460 at async l (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:97492) at async w (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:100345)Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV and 1 XLSX). I then have Power Query clean up that sheet to generate a report. The CSV and XLSX are also cleaned up with Power Query prior to the calculations taking place. The output of the final report looks like this: I would like to know the total count of people, the unique count of people, the number of people who are the sole owners, the number of people who are listed with other people who do have access. As you can see behind the blur under "Triggered Owner", there can sometimes be more than one. The tricky part here is that I would like to track these numbers in a new row in a table for each refresh, similar to the below, where the data doesn't completely erase each time. Run Date is when the refresh occurs. Is this possible?
Need Help! I can't Sort
Hi. I'm having trouble by sorting data (A to Z and Smallest to Largest). When i select data like this and then i click on Sort it doesn't work: When i Click on sort a, Progress Bar with the name "Sort:" appears and it doesn't work: I need help because i use Excel on my job and this problem makes it a lot harder.
chart / data range to variable ??
Hello, I draw a chart with specific data range C11:C20 like below. but I want to change data range of chart dynamically. I made data range text in cell E5 and it is B10:B100. How can I make E5 text as data range text of chart ? is it possible? I'd like to redraw chart dynamically when I change E5 cell text.
Alternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a spreadsheet with 3 tables located in separate sheets: SKU, Production, and Expected. In the SKU table I have a list of item codes that are part of a general Category. In the Production table, I pretty much have a manual log of the number of Units that I produced in different Dates for each Item Code that applies. In the final table I pretty much just have a table with the Dates. The file I uploaded has a total of 4 columns in this table, but in my actual document the last 3 columns are actually arrays. I just placed them inside the table for purposes of this example. Anyhow, columns B-D are the Categories each Item Code belongs to: Blue, Green, or Red. What I'm trying to do is as follows: I'm trying to do the equivalent of a SUMIFs formula for Blue, Green, and Red. It first checks that the date in the Expected sheet matches the date in the Production sheet. Next, it checks in the SKU table which Category the Item Code belongs to for the selected date. It then adds the total Units for each Category column. I've tried with variations found online of SUMIFs and SUMPRODUCT, but I haven't been able to make them work. Any and all help is greatly appreciated.Excel Office Script "Performance API"?
I was working on an Office Script and trying to improve the performance. I typed "Performance" into the code editor, and I was suprised to see the Intellisene kick in. My question is how to find and understand the relevant documentation for Typescript applicable to Excel Office Scripts. I could not find this object/API in official MSFT Office Script documentation. Icing on the cake would be a suggestion for a more sophisticated way of measuring performance bottlenecks on an Office Script. I have attached a screenshot of the object and Intellisense. TIA!Dynamic stuff never works for me
hi, I have been following kenji explains videos and none of the dynamic stuff he does with numbers ever works on my excel but everything else does examples: I was making a live stock portfolio tracker and when I would change which stock I wanted to see, it was supposed to show up on the graph but when I would change it, it would glitch out and not show any stock, Also I made a chart for a DCF calculation for an expected stock price and the stock numbers were very unrealistic, I also am now doing a budgeting forecast and everything was working up until I started to make a dynamic or live forecast and it didnt work again IDK if this is a settings thing but IDK, can anyone help :)
