excel for mac

Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). Ex: Total Goal Amt: 5000 End Date: Dec 2026 Total # of Months till completion: 24 (*calculated...

Hi, Need to count any numbers from a 2D array if it is standalone in a horizontal row - formula needs to work for whatever column its in Ex: COLUMN A COLUMN B COLUMN C COLUMN D 25 94 83 92 78 32 56...

Hi, I have an array full of prices and 1 date column. I need to display the most recent value of each row's array that are all equal to today's date. I plan to sum all the numbers eventually. Ex: TODAY'S DATE: July 4th 2024 04-Jul $14.00 $45.00 78.00 18-May $63.00 $86.00 $92.00...

Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. I have a formula but it uses the "OFFSET" function and I need to do this without volatile functions in Excel. Thanks in advance! Ex 2024-11-18 2024-05-12...

I have two Data Tables that I would like to combine into one Pivot Table in Excel for Mac. I have Excel for Mac 2019, version 16.54, so a lot of the solutions that are available online seem not to be available for me, such as combining source data into a new table through a Power Query, using...

One of the best things about the Quick Access Toolbar in Excel for Windows is that it automatically creates shortcuts for the items included in your Quick Access Toolbar. For example, pressing Alt+1 triggers the first item in your Quick Access Toolbar, pressing Alt+2 triggers the second item...

I recently moved to a Mac computer at work and cannot figure out how to mix report layouts in a pivot table. Is this feature available in Excel for Mac? For example I want my report layout mix compact and tabular: <tbody> Customer Year State Product Customer A Widget X...

Excel Mac click to call Skype I am trying to get my phone numbers in excel to call using Skype, but it keeps trying to use Facetime as the dialer. I managed to add a hyperlink and concat formula to give me a clickable link < =HYPERLINK(CONCAT("Tel:",G371)) > and at first, it would open...

Friends, How can I call a stored procedure from Vba Excell for Mac? Thanks

Hello all! I tried to search this on the threads, but I wasn't able to locate if this has been asked. I teach a class in Excel. We use Excel for Mac 2016. One of the students upgraded to High Sierra. In the lesson, we do pivot tables and then create charts off of those pivot tables. He went...

Hi, This code is to send data to another spreadsheet and its not returning any bugs but it just isnt sending the data? can anybody sot something im missing or just not seeing :eeek: -Excel for Mac Thanks! Sub Workbook1()Dim LastRow AsInteger, i AsInteger, erow AsInteger LastRow =...

Hello there, im experiencing problems in using Macros in Mac OS Excel platform. I actually created a userform on Excel enabling data entry in terms of name, department and costing to be inserted directly on an Excel sheet database as backup but when i try to use the same on a Mac OS Excel...

Hello, I am really tired to tried to find a way to edit/customize the ribbon, I need the clear contents button be accessible without having to open the dropdown list every time. Thanks in advance...

I'm running into an issue where I can't seem to figure out how to rename a shape within Excel for Mac. I am trying to use the Name Box and am hitting the ENTER key to confirm the name change, but it doesn't work!!! Anyone know how to accomplish this (seemingly) simple task? Thanks!

Hello everyone, I am trying to build a pivot table from two different tables in Excel, I read about "Data Model" but it's just not there in Excel for Mac, which I have. Any ideas of how this can be done? My excel version: 15.13.1 Thank you!

Does anyone have experience using add-in's with Excel for Mac?

I've had trouble searching for this and I am thinking this is relatively easy to figure out but I'm stuck! Excel Version: Excel for Mac 2011 Data: 2012 Monthly Sales Goals (12 columns) What I am trying to do: Convert my 2012 monthly sales goals to weekly sales goals for reporting. My...

Hi All, My company just moved me to a mac, and excel for mac is very different than the pc/standard version. Does anyone know how to remove all subtotals from pivot tables? I cannot get the subtotal rows to disappear and it is driving me crazy! o.0 Thanks allen

I have a list of part numbers (over 1000 at the moment) in column A of sheet 1, Columns B,C,D and E all have relevant information about the part number, size, weight etc. On a separate sheet I have created a sort of 'order form' using a Vlookup function. I have also created a drop down screen...