I'm trying to use nested subtotals in Excel for Mac 2011, following the instruction to do outer subtotal first and then inner subtotal, but the resulting subtotals are in the wrong order (outer subtotal first, then inner subtotal, where it should be the other way around).
Jump to:. Sponsored Links Next. 1. My red X on my title bar is grayed out how can I get it back? I'm working with the Workday fomula, but the number i Received is a serial number, I would like to change it to a date format. 3.
Can someone please tell me what I am missing here. I use the followig function to concatenate two columns of dates.
![Collapsing subtotal in excel 2011 for mac free Collapsing subtotal in excel 2011 for mac free](/uploads/1/2/5/4/125446030/897977636.gif)
When I use the fill handle to autofill the function down the column, the values calculated in the first cell of the column are carried down the column - without recalculating or updating for each individual iteration. I cannot seem to force the function to recalcuate or examine each iteration of the function independently? Any help appreciated. Public Function OsteoDate(MyText) as String Dim FromDate FromDate = ActiveCell.Offset(0, 1).Text Dim ToDate ToDate = ActiveCell.Offset(0, 2).Text If MyText = ' Then 'Check to see if first date column is null OsteoDate = 'on ' & FromDate Else 'concatenate both dates together with 'from' and 'to' OsteoDate = 'from ' & FromDate & ' to ' & ToDate End If End Function.
4. I have a column of names in capitals and want to use the PROPER formula to convert these to Proper case in the column next to it. However, the spreadsheet has been sent to me and seems to have a 'bug'.
If I fill in the first entry, then try to drag and fill for the remainder, it repeats the first name in every cell. There is no constant $ in the formula. I tested the formula on a completely new spreadsheet using random, not copied, names and it works fine. Is there something I should check to get my column to fill properly?
I created a 10 sheet document. Each page imports pricing & customer information from my 2 main pages.
I was working in the spreadsheet and went to save and it gave me an error while saving. Now I cannot open the document from my PC at work but am able to open the document up at home. Similar Threads: 1. For a sub total in another subtotal I'm look ing for the second selection.