Dear All,
My excel file contain dates and months, Jul, Aug, Sep
Now what I want is to get the highest and lowest value for a specific date, say I want to get the highest/lowest value on 01 Jul, or 02 Sep, etc
Thanks
Dear All,
My excel file contain dates and months, Jul, Aug, Sep
Now what I want is to get the highest and lowest value for a specific date, say I want to get the highest/lowest value on 01 Jul, or 02 Sep, etc
Thanks
Last edited by rcahayag1925; 08-02-2019 at 11:13 PM. Reason: failed to attach file
First, make sure that your dates are true dates and not text format. Then you can use the Min and Max function that are native to Excel.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
sorry Alan i forgot to attach my excel file.
Lowest
=AGGREGATE(15,6,$C$2:$C$68/(--F$2:F$161=I$4)/($G$2:$G$161=J$4),1)
Hightest
=AGGREGATE(14,6,$C$2:$C$68/(--F$2:F$161=I$4)/($G$2:$G$161=J$4),1)
thank you Bo_Ry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks