Formula for cross tab data filling

M

moonhkt

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
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
help on a formula (match and etc..) 1
Could Use Some Help With A Formula 2
Lookup (more complicated) 2
VSTO C# add in Outlook.Appointment error 0
Query Help 5
Convert column data into multiple rows 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0

Top