Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Help with this please...

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Dave Shannon
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =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. #4
    New Member
    Join Date
    Mar 2002
    Location
    Dave Shannon
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Much appreciated!

    Dave

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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