Hi
Please can you help me .
My spreadsheet is like this (please see the attached):
1. Column A : Dates (Every day's Date):
2. Column B : Data numbers (daily value)
3. Column C : is month in numerical manner
3. Column G-S: Is where I want the formula to be: Determine monthly values according to different categories (Min, Percentiles, Max)
The formula must look at every in-Column C and the corresponding data in column B and generate the outputs (Monthly basic) as indicated from column G-T.
Many thanks
Bookmarks