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

« XL12 'Close' button doesn't shutdown XL | Averageif Approximate Match »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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