Heavy onions
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Heavy onions

  1. #1
    Guest

    Default

     
    Dear MrExcel,
    This is the situation:
    Three columns- A, B, and C

    A B C
    p 1 potato
    q 1 tomato
    r 1 ketchup
    p 2 cheese
    q 2 onions
    r 2 garlic
    p 3 peper
    q 3 salt
    r 3 eggs
    . . .
    . . .
    . . .

    How to select the item from the column C
    that has the same row number as the value q in the column A and as the value 2 in the column B? (that is onions here)

    Thanks,
    KHE/E

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wouldn't an AutoFilter do what you want? Just choose your column A criteria (q) and column B criteria (2) and since this is an "And" situation, the value which would pass that And criteria combination is Onions.

    Any good?

    Tom Urtis

  3. #3
    Guest

    Default

      
    No, Tom, please read:
    Does Excel support onions?

    KNELE

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