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 <What formula>
21,9,29 22,7 11,13 < makes this?>


Thanks for any and all help

 

[Mark W.]

On 2002-03-06 08:35, dshannon wrote:
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 <What formula>
21,9,29 22,7 11,13 < makes this?>


Thanks for any and all help

I'd create a PivotTable with Size in the COLUMN area, 'Jersey #' in the ROW area and Sum of Qty in the DATA area.