PC Review


Reply
Thread Tools Rate Thread

Formula for cross tab data filling

 
 
moonhkt
Guest
Posts: n/a
 
      22nd Mar 2011
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook mail box keeps filling and filling multi of same email April Microsoft Outlook Installation 1 21st Feb 2010 03:57 AM
"Cross"-Auto filling: consecutive columns into rows AndreasW Microsoft Excel Worksheet Functions 1 19th Oct 2009 01:46 PM
Cross Tab Query Total Formula sborgemenke@cincinnatichamber.com Microsoft Access 1 7th Jun 2006 07:36 PM
filling information from one cell and filling another. =?Utf-8?B?RGlhbm5l?= Microsoft Excel Worksheet Functions 1 15th Aug 2005 08:14 PM
Help creating a custom formula field to use in a Cross-Tab Report. =?Utf-8?B?RWR1YXJkbzc4?= Microsoft VB .NET 0 8th Jun 2005 01:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 AM.