Help with this please...

dshannon · Mar 6th, 2002, 09:41 AM

If I am creating a sheet listing size, qty & jersey #. How can I list the different jersey numbers under 1 size...

ex:

Size----------------Qty--------------Jersey #
AM------------------1------------------22
AS------------------2------------------21
AL------------------1------------------11
AL------------------2------------------13
AS------------------1------------------9
AS------------------1------------------29
AM------------------1------------------7

AS #'s-----AM #'s-----AL#'s
21,9,29----22,7-------11,13
what formula would I use to list the numbers below the sizes as shown above?

Thanks for any and all help

Nobby · Mar 6th, 2002, 09:51 AM

Easiest way is to use a Pivot Table - you'll find it under Data/Pivot Table.

When you've gone through the basic steps of the Wizard, click on Layout.

You should see 3 buttons, Size, Jersey# and Quantity.

Drag Size into Row, drag Jersey# into Column and drag Quantity into Data. Double click on Quantity and change from "Sum of" to "Count".

Should do it.

Nobby

mrowe · Mar 6th, 2002, 09:58 AM

=VLOOKUP(A2,$E$2:$F$4,2,FALSE)

Col A = Size
Col B = Qty
Col C = Jersey #

Range E2:F4 as follows
AS 21,9,29
AM 22,7
AL 11,11

Should solve your problem?
Matt

dshannon · Mar 6th, 2002, 11:36 AM

Thank you both ... I tried both and got them to work.

Much appreciated!

Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:41 AM	#1
dshannon New Member Join Date: Mar 2002 Location: Dave Shannon Posts: 3	If I am creating a sheet listing size, qty & jersey #. How can I list the different jersey numbers under 1 size... ex: Size----------------Qty--------------Jersey # AM------------------1------------------22 AS------------------2------------------21 AL------------------1------------------11 AL------------------2------------------13 AS------------------1------------------9 AS------------------1------------------29 AM------------------1------------------7 AS #'s-----AM #'s-----AL#'s 21,9,29----22,7-------11,13 what formula would I use to list the numbers below the sizes as shown above? Thanks for any and all help

Mar 6th, 2002, 09:51 AM	#2
Nobby Board Regular Join Date: Feb 2002 Location: United Kingdom Posts: 68	Easiest way is to use a Pivot Table - you'll find it under Data/Pivot Table. When you've gone through the basic steps of the Wizard, click on Layout. You should see 3 buttons, Size, Jersey# and Quantity. Drag Size into Row, drag Jersey# into Column and drag Quantity into Data. Double click on Quantity and change from "Sum of" to "Count". Should do it. Nobby

Mar 6th, 2002, 09:58 AM	#3
mrowe Board Regular Join Date: Feb 2002 Posts: 232	=VLOOKUP(A2,$E$2:$F$4,2,FALSE) Col A = Size Col B = Qty Col C = Jersey # Range E2:F4 as follows AS 21,9,29 AM 22,7 AL 11,11 Should solve your problem? Matt

Mar 6th, 2002, 11:36 AM	#4
dshannon New Member Join Date: Mar 2002 Location: Dave Shannon Posts: 3	Thank you both ... I tried both and got them to work. Much appreciated! Dave