Get instant live Excel expert help to learn how to create a statistical function in Excel?

I am having trouble with a median calculation using nested ifs. This time it's for a text status within date range.

i am having trouble with a median calculation with nested if criteria. i need to find the median sales price within a date range. last time i tried excelchat was having technical issues with downloading so trying again.

In cell J6, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in cell B15; otherwise, have the word Over display. Use the named range for B15 when entering this function. Copy this function to the range J7:J10.

In cell C3, use a function to calculate the median amount spent at the spa by the wedding parties.

I'm looking for a formula that can help me find the median of a list of numbers from different types of materials for example Batteries = 0kg Batteries = 2kg Batteries = 1kg Batteries = 1kg Cans = 0kg Cans = 0kg Cans = 0kg Cans = 1kg Cans = 1kg Coffee Capsules = 0kg and so on .. and from there i can find the possibilities of any anomalies from numbers' column based on the material please help

I'm looking for a formula that will help me find anomalies in my Median column if the calculated value is 35% above the median then consider it as an anomaly

I need to add a new column following each time "Total_Billed" appears in the first row. The new column needs to be named "Store Ref" and the 4 digit number that appears in each of the 3 column headers that appear to the left of the new column needs to be filled into the new column up until the last active row. This needs to be dynamic as the size will change with different files. Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of discounts vary frequently. Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format. This needs to be completed with a macro!

I need to add a new column following each time "Total_Billed" appears in the first row. The new column needs to be named "Store Ref" and the 4 digit number that appears in each of the 3 column headers that appear to the left of the new column needs to be filled into the new column up until the last active row. This needs to be dynamic as the size will change with different files. Then the first 3 rows need to be appended 20 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of discounts vary frequently. Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format. This needs to be completed with a macro!

Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the next 4 rows (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of rows will vary frequently. this needs to be done using a macro

Then the first 3 rows need to be appended 21 times (not including the column headers). Each set of count, applied amount, total billed, store ref need to be appended to the first set (not including the column headers). When it is finished the final product will have a total of 7 columns. It will have 20*20 = 400 rows + 1 header row. The appending of the columns need to be dynamic as the # of discounts vary frequently. Please take a look at the sample as its much easier to visualize. Basically I need to create a table that has a better format. This needs to be completed with a macro!