Named Range

[How_Do_I]

Looking at Column BA in my Jeanie… How would I making an expanding named ranged for all the data in that column please?

Excel Workbook
	BA
6	15-Mar-11
7	15-Mar-11
8
9	22-Mar-11
10	29-Mar-11
11
12	15-Mar-11
13	15-Mar-11
14	22-Mar-11
15
16	15-Mar-11
17	22-Mar-11
18
19	30-Mar-11
20
21	30-Mar-11
22	19-Apr-11
23
24	15-Mar-11
25	22-Mar-11
26	22-Mar-11
27	05-Apr-11
28	05-Apr-11
Weeks

 

[Aladin Akyurek]

Define Lrec as referring to:

=MATCH(9.99999999999999E+307,Sheet1!$BA:$BA)

Define Postponed as referring to:

=Sheet1!$BA$7:INDEX(Sheet1!$BA:$BA,Lrec)

Adjust the sheet name to suit.

 

[How_Do_I]

Thanks Aladin ... your part of what I'm trying to do is brilliant and it works...

If I select all the highlighted cells (15 Mar 11) except the top one, and right click>delete>shift cells up. I get a REF error for one of your formulas. Am I asking xl to do too much please?

 

[How_Do_I]

I've sorted this now Thanks again Aladin.