Forum Widgets
Latest Discussions
Conditional Formatting
Hi guys! I have statistical model results in 8 rows across columns E-H for 8 years of data. I have applied conditional formatting to select the greatest r-squared and the greatest top 30 r-squared. I have also applied conditional formatting to select the least greatest standard errors. I would like to paste those conditional formatted results in empty cells below the years of data. How do I achieve this?
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
