Thanks:  0
Likes:  0

# Thread: Help with this please...

1. 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

2. 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

3. =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

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

Much appreciated!

Dave

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•