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.
VLOOKUP help required
I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the project lifecycle entered by the user. =VLOOKUP(H4,Category,2,FALSE) – this works fine and is using Lookup table 1. On the main worksheet, the user will enter in a score for each of the Project Elements (ranging from 1- unacceptable to 5-excellent). What I need to do is – based on the Category, apply the appropriate Weighting factor to the Project Element Scores (lookup table 3) and output that value into another column (called Project Element Weighted Score). Lookup table 1: Lifecycle Category 1-Investigation 1-Conceive 2-Definition 2-Design 3-Implementation 3-Build 4-Production 3-Build 5-Frozen 4-Manage 6-Phase out Started 4-Manage 7-Phased out 4-Manage Lookup table 2: Category Project Elements Score Output value weighting 1-Conceive Personnel 5 5 1 1-Conceive Personnel 4 4 1-Conceive Personnel 3 3 1-Conceive Personnel 2 2 1-Conceive Personnel 1 1 1-Conceive R&D 5 5 5 1-Conceive R&D 4 4 1-Conceive R&D 3 3 1-Conceive R&D 2 2 1-Conceive R&D 1 1 1-Conceive Infrastructure 5 5 2 I have in the weighted score field on the main spreadsheet and a VLOOKUP formula that was working prior to introducing the Weighting by Category concept. I can’t figure out how to include a lookup to to get the category and the corresponding weighting factor and use the correct weighting factor to apply to the score. I hope I’ve been clear enough - I cannot send my spreadsheet as it has c
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 (https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4), 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 (https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4). 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 -> https://superuser.com/questions/950100/connect-to-postgresql-database-from-excel-2013-power-query-with-npgsql
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.
