Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
NP
 
Posts: n/a
Default Creating a summary from existing spreadsheet data ...

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


  #2   Report Post  
Paul Corrado
 
Posts: n/a
Default


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




  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

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



  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

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



  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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



  #6   Report Post  
NP
 
Posts: n/a
Default

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






  #7   Report Post  
NP
 
Posts: n/a
Default

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





  #8   Report Post  
Paul Corrado
 
Posts: n/a
Default

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








  #9   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
I am having problems creating pivot table of data wyman Charts and Charting in Excel 1 January 12th 05 06:17 PM
Importing Data From Another Spreadsheet Tiziano Excel Discussion (Misc queries) 6 January 7th 05 03:35 AM
Creating a Microsoft Words document from an existing Excel spreads ringo tan New Users to Excel 1 December 30th 04 09:01 PM
Entering data on template and then data going to a spreadsheet. KJH Excel Discussion (Misc queries) 3 December 24th 04 02:04 AM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"