Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

Use the SUMIF function if you only have one criteria.



"NP" wrote in message ...
Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select
all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

Hi
'Data - Filter - Advanced Filer'
or even try using 'Data - Filter - autofilter'

For an addin see:
http://www.rondebruin.nl/easyfilter.htm

"NP" wrote:

Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

Hi
see your other post

"NP" wrote:

Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

One way:

Record a macro doing an advanced filter.

With a little editing, I got

Public Sub AutoFilterAs()
Range("C1").Copy Range("E1")
Range("E2").Value = "A"
With Range("A1").CurrentRegion
.AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("E1:E2"), _
CopyToRange:=.Offset(.Rows.Count + 2, 0).Resize(1, 1), _
Unique:=False
End With
Range("E1:E2").ClearContents
End Sub

See

http://www.contextures.com/xladvfilter01.html

for more help.



In article , "NP" wrote:

Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

how would i use this please?

NP.


"Paul Corrado" wrote in message
...

Use the SUMIF function if you only have one criteria.



"NP" wrote in message ...
Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select
all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

is there a way to summarise B's and C's also in a separate summary?

thankx,

NP.


"Frank Kabel" wrote in message
...
Hi
'Data - Filter - Advanced Filer'
or even try using 'Data - Filter - autofilter'

For an addin see:
http://www.rondebruin.nl/easyfilter.htm

"NP" wrote:

Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is select
all
of the items with a Condition of A and place them in a little summary as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

NP

I don't think I understood your question correctly when I posted my reply.

Frank has a better answer




"NP" wrote in message ...
how would i use this please?

NP.


"Paul Corrado" wrote in
message
...

Use the SUMIF function if you only have one criteria.



"NP" wrote in message ...
Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is
select
all
of the items with a Condition of A and place them in a little summary
as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A

copy the data to a new worksheet

Sort on the third column

Put in some rows to separate the data.

After you sort, you can select the data and do

Data=Subtotals
select the third column and count

--
Regards,
Tom Ogilvy

"NP" wrote in message ...
is there a way to summarise B's and C's also in a separate summary?

thankx,

NP.


"Frank Kabel" wrote in message
...
Hi
'Data - Filter - Advanced Filer'
or even try using 'Data - Filter - autofilter'

For an addin see:
http://www.rondebruin.nl/easyfilter.htm

"NP" wrote:

Looking for a solution to this little problem in Excel ...

Cells A1 to C7 contain the main data. What I would like to do is
select
all
of the items with a Condition of A and place them in a little summary
as
shown in A9 to C12. Any ideas how to automate this please?

Many thanks,

NP.

Spreadsheet:

A B C
1 Pt No. Desc Condition
2 1 Apple A
3 2 Pear A
4 3 Banana B
5 4 Orange A
6 5 Grape C
7 6 Sultana B
8
9 Pt No. Desc Condition
10 1 Apple A
11 2 Pear A
12 4 Orange A