Hi all,
I just got a problem with determining dynamic ranges.
As shown below, I would like to declare a range whose dates are between 01/9/2013 and 30/9/2013 so that I could do some lookup in this range. Then I would like to re-declare a range whose dates are between 01/8/2013 and 31/8/2013 and so on.
How could I achieve the goal?
Many Thanks!
A B C D
1 NE 19/9/2013 Transportation -4.4
2 NE 18/9/2013 Transportation -4.4
3 NE 17/9/2013 Transportation -4.4
4 JC 13/9/2013 Other -10
5 NE 10/9/2013 Transportation -40.1
6 BC 8/9/2013 [Cash] -600
7 TF 1/9/2013 ABV -500
8 NE 31/8/2013 [Cash] 3398.5
9 NE 13/8/2013 Transportation -40.1
10 NE 5/8/2013 Transportation -4.4
11 JS 4/8/2013 Joint -60
Bookmarks