Help with this please...
Power Query Course in Spanish
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

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
  •  

 

 
DMCA.com