Trying to get the DISTINCT value for a specific Date and Code

**antexity** · 03-23-2015, 12:38 PM

Please see attached.

Regarding only Tab "TOP 3 Daily Trend"

I achieved to get my top 3 values for the month (A2:C6). That's good, No help there.

What I need help on please, based on the top 3, what are my # of defects per day within the date range provided for my Top 1 item, top 2 etc.

Another nice to have would be the ability to list the dates that are available instead of having the NUMs. The reason why I have those NUM, is when the Month changes and there is date for almost every day I need to have the formula predefined just in case.

I have highlight in yellow the expected results.

Expected functionality, on April 1st, the date range should change from March 1 - 31 on the Top 3 and then the defect trend section, all the dates where data exist should be labelled across, and the values and charts should change.

The chart will be a line chart with Dates on the x axis, # defects per day on the Y and the lines are the Top 3 values.

Thank you so much.

Samplev1.xlsx

**Glenn Kennedy** · 03-23-2015, 01:00 PM

Hi there. see the array formula in the tan coloured cells. Array formulae must be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.