PowerView Multiples : Greyed out => not available
While giving a Training related to PowerView I couldn't explain the option Multiples, because they were greyed out. When selecting fields, Power View itself decides to place the field in the multiples. That I can accept, but it was impossible to move the field, delete the field, ar place another field in the option Remark: it was op the classroom PC not on my personal PC Someone got an idea?
General Mail Failure when trying to share as pdf in Excel 2013
Hello Can anyone help to resolve this issue? We can still successfully email files in xlsx format. I can still save as pdf. The only problem is to share as pdf from Excel ( it works in Word) We have Excel 2013 installed on Windows 10. I have already tried: checking that Outlook 2013 is default reinstalling Office restore point to the date when everything worked was corrupted and was deleted by the system running Mapifix
Formula or function for IF statement based on cell color
I don't know how to code in VBA but am trying to automate an if/then calculation based on cell color. As shown in the picture, if the colors of the cells in column B are the same as those in Column G across the row, I want to subtract the values in columns F and K in the same row to return the absolute value of the subtraction in column L. If the colors of the cells are different, I want to add the values in columns F and K and return the value in column L. I will have multiple tables of varying numbers of rows where I need to perform this operation. Any help is greatly appreciated.
IFS statement using concat
I have a sheet I am trying to combine values into one cell based on 2 cells. For example: Member 1 Drug1 Flag1 Member1 Drug2 Flag1 Member1 Drug3 Flag1 Member2 Drug1 Flag1 Member2 Drug1 Flag2 Member2 Drug2 Flag2 I am trying to say if Member 1=Member1 and Flag1=Flag1 then concatenate the drugs for those flags into a column. Ideally I would like to have Member1 Drug1, Drug2, Drug3 Flag1 Does anyone have any ideas on how to present this? Thanks so much!
Connect to PostgreSQL with Get & Transform in Excel 2016 (Npgsql)
Hello Folks :) As recomended by the Office Support page (link), I'd like to start a new conversation on how to ingegrate PostgreSQL in this forum as I cant find (after 2 hours of searching) any simple sollutions out there. Am tyring to get Excel (2016 Professional 32 Bit) comunicating with a PostgreSQL Server and what is recomended to consider by the official Support Page to this topic is not enough. Here where I got stuck running in circles. Once you click, learn more you get back to the Suport page. As recomended by the Support page, I installed Npgsql, restarted Excel *(and even the PC), ... made sure that the Npgsql is at "C:\Windows\Microsoft.NET\assembly\GAC_MSIL" and still am not getting any further and when searching for more info online I always only get referenced back to the same suport page (link). Does anybody know: 1.) Is connecting to PostgreSQL a 365 only feature & if yes, shouldnt that work with Get & Transform 2016 as well ? 2.) Anybody Ideas on where I could research further into that ? Edit 21/06 - a lot of info this problem can also be found at following page -> link
Averaging only Subtotals in a column
I am trying to average only subtotals in a column. The column includes the data for the subtotals also. I want to be able to only average the subtotals that have a value greater than zero. I came up with a formula that comes close to what I want, except it will average zeros also. =IFERROR(SUBTOTAL(9,O160:O195)/(COUNT(O160:O195)-SUBTOTAL(3,O160:O195)),0) Is there a way to accomplish only averaging subtotals. When writing this, I need to be able to add additional lines and subtotals in the column occasionally and have the formula include those when averaging.
