Forum Widgets
Latest Discussions
Transform multiple date ranges into continuous dates list through Dynamic Array
Hi Excel experts, I have data in a table format with StartDate, EndDate, and Amount columns. The data needs to be transformed into an output format that consists of Date and Amount Per Day columns, i.e., date ranges need to be flattened into a single column and Amounts need to be divided into the count of days within a range for each row in the input table. I was able to achieve this result through Power Query (M language). I would really appreciate it if you could submit only dynamic array formula solutions for this challenge. Link to the example file: Example for Dates and Amounts per Days from Date Ranges ThanksAll the rows after last "8" in PQ
Dear Experts, Can you please help on how to get a column for all the elements after Last-8 in below Table ( not sure of we can use Table.LastN to do this, but without M-code:- So, in the New Column, I should have, ,6,15,4,..12 Using UI, Thanks in Advance, Br, AnupamExcel formula troubleshooting
Hi everyone. I am using excel online to try and become a data analyst. now I have troubles with the formulas. I am doing what is supposed to work. " =sum or subtotal (I2:I38) and press enter but the end result is overflow. what is going wrong here? Help would be very welcome.
User-Defined Fit Functions
Hello, there are several predefined data fit functions in Excel, such as a polynomial fit – I thinks a data fit is called a "trend line" in Excel. I have the following question: Is there a way to *define* custom fit functions, and make Excel to use those instead of the built-in ones? Is there an "add-in" or something I could use? Any help would be greatly appreciated. Thanks very much, rflesch
Formula for age
Formula for age of a participant of a study whos doing training, with the birth day and the start date of training . I used the formula: fx=DATEDIF(H1;T1;"Y"). where H is the column of birthday and T the column of trainingsdate. the adminstrator has defined the dates for each column between 2018-2040. As the birthdays are all before 2018, i get an error and can not do the calculation of age in this way...is there another possibility to calculate the age of the participant?
