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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Funster

    Filling cells with Serial Port Data

    Funster, Feb 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    214
    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:
    131
    Saeid
    Oct 14, 2006
  3. Filling formula using macro

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

    finding last empty cell and filling data to the left

    ali, Jul 29, 2007, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    154
    Rick Rothstein \(MVP - VB\)
    Jul 29, 2007
  5. Dave K

    Filling in blank rows in a Table of data

    Dave K, Sep 16, 2009, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    190
    Dave K
    Sep 16, 2009
Loading...

Share This Page