Hi RW9, Thank you for your answer! I put here an example with numbers because my table is with dates but I can´t copy it here (I work in a protected server). To be more detailed, there is a table with dates (Var2) by cities (Var1). I need to find the day before and after of these dates but in cases of periods, I need the day after and before of the period! That is why I said that I look for the max and min of the numbers in order and not the max and min only by Var1. I would like to find the Min and Max by period (numbers in order) and Var1. I hope it helps more! Thanks a lot, Maria
... View more