Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8
I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...
I have following table and need help on sum total of Value 1 column.
I am looking for a formula which would return value based on the following criteria:
If Value 1 = Value 2 then exclude that...
Need help to convert data from column wise to row wise.
My current data set is as follows:
I am looking for a result as follows:
Thanks in advance.
Hi, I am new to Power Query and have an issue with a task which is relatively easy to complete in excel.
I need to get a loop calculation where the next output is dependant on the previous output in two places. Please see below for a brief snapshot.
The Starting point is 100 and no calculation...
I hope I can explain this correctly.
I need to calculate a KPI using %, I got as far as creating the target.
Column D is the target of 100%, so if the target is met then the achievement is 100%, I need to calculate the achievement with a max of 200%.
Any ideas on how to get this done?
I have two sheets with follow data:
I am looking for a formula/way to copy data from above sheets to a third...
I am totally new to Power BI, the Power Query Editor and most of all the M language. I wanna try to import data from different Excel documents using the Power Query Editor and then merge different columns from these separate documents using the joins function. Finally, I plan to add...
I have a stacked column chart with dates on the x-axis and different codes on the y-axis. I would like to set-up a drill through / drill down function for the codes on the y-axis but I don't know how to do this.
For example, one of the stacked column is the code "3xx". This code is...
Hi, I am trying to write a formula that will tell me if a client is new or existing. Below is some sample data of the file I am working with.
I am struggling with copying over a filtered table from one workbook to another. the workbooks are both open.
The table is in the commission tab in the Sales Master - 2018.xlsm file
So, I need to filter the table to show all the data of the name of the person at the end of the...
I just upgraded to Win 10 and Excel 2016 (64 bit), was previously on Win 7 and Excel 2013. I disable "allow editing directly into cells" within the options so that all my editing is done in the formula bar. In Excel 2013, when pressing F2 to edit a formula, the font would change color...
I'm totally new to Power BI and currently stucked with my work... For you it might only take a few minutes, but for me it would mean a forune!
What I would like, to have a slicer that starts from "Service Created". So I only see the Services that has been created before the chosen...
Hey you all,
I am pretty much a newbie to the whole Excel macro area and I tried my best to Google the answer for my problem but couldn't quite find a satisfying solution to it. So what I am trying to do is to censor all names from an Excel file by replacing the very next word of "herr", and...
I can't seem to figure out a formula for this. Please help! I want it to count business working days in numerical output for when I should Order the part based on the date I open the excel file compared to Due Date with Lead Time.
Program Due Date
i need with a formula to do the following calculation
1 determine the quarter that a date falls in and then compare it to the last quarter of the year.
2. Determine the number of months in each quarter and then prorate an amount based on the number of month in each quarter.
I have this example in my onedrive. Link: https://1drv.ms/f/s!As8YC7wZr8RKist1_Ql70SsOKar7yA
I create the measure MEDIAN. I would like to count how many itens in the Subcategory column Greater Than the MEDIAN.
Could this calculation be done as a measure, not column?
Here is an example with my challenge click (onedrive files)
I following cues from
and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/
I am trying to get...