Help with this please...

[dshannon]

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]

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]

=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]

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

Much appreciated!

Dave