Formula for cross tab data filling

Discussion in 'Microsoft Excel Discussion' started by moonhkt, Mar 22, 2011.

  1. moonhkt

    moonhkt Guest

    Hi All

    Excel 2003

    How to using formula for data filling as below (Y/N) ?

    Sheet A
    Product A Product B Product C
    System A Y N Y
    System B Y Y N



    Sheet B
    System A Product A
    System A Product C
    System B Product A
    System B Product B

    moonhkt
     
    moonhkt, Mar 22, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Funster

    Filling cells with Serial Port Data

    Funster, Feb 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    285
    Thomas Lutz
    Feb 17, 2004
  2. Saeid

    How can I make cross from data,Please help me.

    Saeid, Oct 11, 2006, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    198
    Saeid
    Oct 14, 2006
  3. Greggy
    Replies:
    1
    Views:
    396
    Greggy
    Mar 28, 2007
  4. Filling formula using macro

    , Jun 21, 2007, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    207
    Earl Kiosterud
    Jun 21, 2007
  5. ali

    finding last empty cell and filling data to the left

    ali, Jul 29, 2007, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    200
    Rick Rothstein \(MVP - VB\)
    Jul 29, 2007
  6. JMac

    Make lists on new tab from previous tab

    JMac, Jan 17, 2008, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    410
    Ken Johnson
    Jan 23, 2008
  7. Dave K

    Filling in blank rows in a Table of data

    Dave K, Sep 16, 2009, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    305
    Dave K
    Sep 16, 2009
  8. gloriamar

    HELP! how to cross - data with excel??

    gloriamar, Jun 6, 2010, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    462
Loading...