How can this be accomplished - Dynamic ranges??

[Frank3923]

I need to recap the data in column K. based on Data in column A.
Example there is a total of 1 "A-Late" 1 "Okay" and 1 "B-Late" for the Origin of Data-2. the ranges of the items in column "A" can change, so they must be dynamic. I would then like to recap by "Data items" on a second sheet.
Example - Data -1 1 - AHEAD
Data -2 1 - Ahead
1 - Okay
1 - B-Late

and so on.

Any help or direction would be valued and appreciated.

LINEHAUL CUT TIMES-051503-Thursday.xls
	A	B	C	D	E	F	G	H	I	J	K
2			TimeSchedules						Page1of3
3	Origin:	Desc-1	Desc-2	SchCut	SchDept	SchArr	ActDep	Eta	Time
4
5	Data-1	City-1	Data	18:00	18:30	20:30	18:05	22:30	23:35	23.58	Ahead
6
7	Data-2	City-1	Data	21:30	22:00	8:30	22:20	8:20	0:20	0.33	A-Late
8		City-1	Data	22:00	22:30	4:00	22:30	4:00	0:00	0.00	Okay
9		City-1	Data	22:00	22:30	5:30	23:15	2:30	0:45	0.75	B-Late
10
11	Data-3	City-1	Data	21:00	21:30	8:00	21:00	7:30	23:30	23.50	Ahead
12		City-1	Data	21:30	22:00	8:30	22:15	8:30	0:15	0.25	A-Late
13		City-1	Data	22:00	22:30	3:00	23:00	0:00	0:30	0.50	B-Late
Sheet3

 

[kieran]

If I under stand 'recap' correctly, the following may be of help.

If you were to omit the blank rows in the list, then the autofilter function will do what you want.

Pivottables may also be of use in summarising the data too.

 

[Frank3923]

If I under stand 'recap' correctly, the following may be of help.

If you were to omit the blank rows in the list, then the autofilter function will do what you want.

Pivottables may also be of use in summarising the data too.

Thank you, I will consider this as one of my options.