Microsoft Excel - Select first date of each month and corresponding value
Asked By Rocky on 14-Feb-13 05:16 AM
Ive two columns, Column A with set of dates for each month and the next column wih it's corresponding depth measurement value. I need to first need excel to select the first date for each month and then it's corresponding value. For Ex:
I need excel to provide the values of 1/02/12 and 02/01/12 in this example i.e. 12 and 18.