sir drinks alot
New Member
- Joined
- Aug 1, 2006
- Messages
- 37
sheet:
how can i sort by date, ascending order, of only the active dates?
anybody got some sweet sort code or something?
thanks.
Book2 | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
2 | DATE | ACTIVE | ||||
3 | 5/8/2006 | A | ||||
4 | 6/9/2006 | |||||
5 | 5/8/2004 | A | ||||
6 | 9/2/2006 | |||||
7 | 4/25/2006 | A | ||||
8 | 4/26/2006 | A | ||||
9 | 4/27/2006 | |||||
10 | 4/28/2006 | A | ||||
11 | 4/29/2006 | |||||
12 | 4/30/2006 | A | ||||
13 | 5/1/2006 | A | ||||
14 | 5/2/2006 | A | ||||
15 | 5/3/2006 | |||||
16 | 5/4/2006 | A | ||||
17 | 5/5/2006 | |||||
18 | 5/6/2006 | |||||
19 | 5/7/2006 | A | ||||
20 | 5/8/2006 | |||||
21 | 5/9/2006 | A | ||||
Sheet1 |
how can i sort by date, ascending order, of only the active dates?
anybody got some sweet sort code or something?
thanks.