need help

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. <colgroup><col><col><col span="25"></colgroup><tbody> Client New/Existing Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17...

Hi All, 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...

Hi all, 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...

Hey guys, 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. <tbody> A B C Program Due Date <colgroup><col width="64"...

Hi All 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. for example...

Hi, 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?

Hi, Here is an example with my challenge click (onedrive files) I following cues from https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-%E2%80%93-part-i/ and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/ I am trying to get...

I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. Col1 qtd cons qtd/cons <tbody style="border: 0px...

Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...

With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...

I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p> <o:p> </o:p> I have created two measures. <o:p></o:p> MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date])) 2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...

<tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...

To dear all. In my vba task, I meet one question like the following. Hope someone can do me a favor. <tbody> <colgroup><col></colgroup><tbody> Random uniform 1 2 3 4 5 6 7 8 9 10 11 12 </tbody> <colgroup><col></colgroup><tbody> 0,964274899 0,038850448...

Hello. I have a problem with code which runs periodically (every 30 seconds). Basically, the code compares data from two Sheets (at the same Workbook) and then paste data (under certain conditions) from Sheet4 to Sheet1. However, when I open some other Workbook (window on that "other"...

Hi brilliant people! I want to sum just the positive transactions in a month, my current code to sum the result of the month is =SUMPRODUCT((MONTH(Logg!$C$24:$BN$24)=C75)*(YEAR(Logg!$C$24:$BN$24)=2016)*(Logg!$C$60:$BN$60)) But i want to sum only the positive numbers, to later get an average...

Hello all, I need to find the weighted average for multiple items within groups within a large data set and dont know if this can be done automatically. I have groups, say multiple investors for one loan and 261 loans. I need to find out the weighted average for each loan and am currently...

This VBA code I am using has a problem I hope someone can help me with. The code is posted below. What the code does is concatenate columns A-G into K but what makes it unique is it bolds the first sentence of each cell in the result column K and preserves the way dates are actually appearing...

I am currently using a macro that eliminates every occurrence where a colon, blank space or zero is the very first character in any cell within columns A,C and E. The problem I am having is that I now need to have formulas in those columns to perform other functions as well and when I run the...