Calculating Two Cells Based on each other
I have a basic task i am trying to complete and i am going through the web to learn how to solve this. Looking for help. I have CAD Currency and USD Currency. I have two cells side by side and depending on what i put in one i want the other to adjust. So if enter to dollars CAD in once cell the other cell will adjust to the equivalent in USD based on a exchange rate in another cell. Any assistance on this would appreciated or even a link to resource to learn how
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with nested if and statements between 2 excel spreadsheets. I have a slightly large spreadsheet with names that are repeating and events repeating thus the file first needs to determine the class so it pulls the right time. The data contains Classes (class A, B and C), Name, Event and Time. Spreadsheet A is the times. Everyone's times are recorded on Spreadsheet A. Spreadsheet B is to track the times per participant on a different tab per participant. In Spreadsheet A, column A is the participant number, column C is event name, column G is the time and column H is the class. In spreadsheet B, (the formula will be in Spreadsheet B). First, I need the formula to look at the class listed in spreadsheet B Column C Row 4 (Class A), then the formula needs to look at column H in spreadsheet A for Class A. Then it needs to look for the rider number on spreadsheet B, Column C row 2 (1234), needs to search spreadsheet A column A for rider 1234, and last it needs to look for the event (Runs) in spreadsheet B, and searches spreadsheet A column C for runs. After it matches all 3 then it needs to return the time in column G. If it does not find all 3 matches, then it needs to leave it blank. IE: Spreadsheet B, Class "A", Rider "1234", Event "Runs", if it meets all three criteria's then return the time in Column G.Compute elapsed time
I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to account for the minutes where the start time minute is greater than the end time minute. Unless someone has another way of computing this.How to wrap table, not vector (WRAPCOLS for tables)
Dear colleagues I have a long table of 5 columns and maybe 200 rows. The task is to wrap the table after a specified number of rows to see the table in landscape on a new sheet. I was thinking about WRAPCOLS, but it works only for vector (one column). Is there a way to wrap whole table using M365 functions? If not, the next option can be Power Query. See example attached. Thank You very much for any hint. Zdenek Moravec Cesky Krumlov, Czechia
Spacing on stacked bar charts
Hi all, I searched for a solution, but changing to 'text' axis doesn't work and that's the only solution I have seen offered. Issue: When using a date axis, there is too much white space / bars are too skinny to be legible despite gap width set all the way at 0. When switching to a text axis, the bar spacing is perfect, but the spacing between dates are at times nonsensical or for some reason it thinks the range is way different than what is highlighted. Here is how the data is highlighted, I only hid columns to make the picture a reasonably proportion the screenshots from above are when no columns are hidden. Is there a way to re-scale the gap-width when using a data axis to effectively to go something like -50%? Or to somehow manipulate the range and the months between labels when using a text axis? Thank you for the help. Matt[52 week high] formula not working
I have a spreadsheet where I track my portfolio data. I have attached a sample. It appears that the "[52 week high]" formula is not working properly. It shows up as the same price as the current "Price" for most securities. While this is in theory possible, the "Price" is below the "[Previous close]", so therefore it appears incorrect. Is this a known issue? How can it be resolved?
Why is Excel suddenly calculating much slower than before?
I've noticed that one of my workbooks has become significantly slower over the past few weeks. It's around 20 MB, contains several PivotTables, XLOOKUP formulas, and conditional formatting. Simple edits now take a few seconds before Excel responds, even though my PC isn't under heavy load. Has anyone experienced something similar? Are there any common settings or features that typically cause this kind of slowdown? Any suggestions would be appreciated.Is XML in Power Query is broken on macOS
Hello, XML from Power Query seems to have broken after update (July 2nd 2026). I tried this on several Macs To recreate just create a new file. Power Query -> XML -> Choose any xml file For me it doesn’t work. It keeps loading endlessly Am I the only one? Is there a workaround? Thank you
