Creating a Matrix (I think?)

Are these 2 actual different files, or 2 different sheets within 1 file?
(if not 2 sheets in 1 file, could they be?)

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

@ Ali, that was going to be my next question

@ Michael, it is almost always better if you can keep all data/calcs etc within the same file - it just makes things that much simpler

Morning, Ford! Coffee time here ...

Hi guys,

Thank you for the clear set of instructions. I understand my initial statement would be a huge pain to work with.

I've mocked up the sample dataset. The 3 tabs are as follows;

1. Desired Result - The end result: The aim is to use 'Data Capture' and map which CSIDs contain which Applications and tag these with a '1'.
2. Summary - Where we hope to capture the data (displayed in desired result)
3. Data Capture - The file containing CSID's with their corresponding Application Names

Hope this helps.

Thanks!

First fill in the blank cells on the Data Capture sheet using the technique in the linked tutorial (video is less then 2 1/2 minutes).
https://www.contextures.com/xlDataEntry02.html
The formula to fill in the matrix is: =COUNTIFS('Data Capture'!$A$2:$A$21,$A8,'Data Capture'!$F$2:$F$21,J$7)
Let us know if you have any questions.