Please Please Please make it clearer which versions of Excel contain Power Pivot
On the office 365 plans page a lot of screen space is taken up highlighting (IMHO) fairly low priorty features for small and medium businesses. The fact that none of these plans contains Power Pivot is much more significant and should be flagged as such. It's a shame that we have to go to an external source like the PowerPivotPro webpage to get a clear view of what versions of Excel contain Power Pivot. https://www.powerpivotpro.com/2015/10/what-versions-of-office-2016-contain-power-pivot/
Formula language problem
Hello, I'm from Switzerland and we speak 3 different languages. Mine is french but the most important is german. I use excel online, the menu is in french, no problem. But when I want to enter a formula, I have to type it in german. That's a problem for me. I didn't find how to change it. Please help me. Thanx Fabrice
adding or deducting a value monthly in Excel
Hi all, Im trying to create a simple excel sheet to add values or deduct values monthly. how can i achieve this in excel to automatically update on let say on every 2nd of the month to add a value, or on 10th to add another value? Anyone that can help me out? Thanks!
Money in Excel - Dual accounts not allowed
New Money in Excel user. Spouse and I both have 401k accounts with the same institution. Money in Excel will not let me import both accounts. Hoping this can be a future fix. I tried to combine the accounts at the institution, but they don't allow combining 401k accounts
*SUGGESTIONS* Function for Dictionary-Like Tables / Invert Filter selection
More often than most things, we index-match Key-Value pairs. Now if the key-value pairs are in a Table, INDEX-MATCH looks really nice: Table1: Key Value 1 Panagiotis 2 Nikos 4 Kostas data Key formula 1235134 1 =index(Table1[Value];match([@[Key]];Table1[Key];0)) 12341234 4 =index(Table1[Value];match([@[Key]];Table1[Key];0)) While that syntax is nice, it can get better: FROM(Table1, "Value", "Key", [@[Key]]) ! How cool is that? ** Also, add the option to invert filter selection. You added that in Windows Explorer, is it not the right time for the Excel too?
Use VBA to Autofill a Row until the end of the number of data in another row
Hello, I need some help with the following problem: The Macro should select the first cell with the vlookup (AY2) and autofill the complete range in the column AY until the last row that contain data in the cell next to it (Column E). Column E is the cell that the vlookup refers to. The situation looks like this: The code that I have so far looks like this: Sheets(3).Select Range("AY2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-41],DennisAR!C[-50],1,0)" Selection.AutoFill Destination:=Range("AY2:AY1662") Range("AY2:AY1662").Select The problem with this is, that the number of rows with data always change every week. So I cannot use a static row number of 1662. I am looking for a way to make Destination:=Range("AY:AY1662) dynamic. In fact it has to refer to the number of rows with data in column E. Thank you very much in advance, Kai
