Forum Discussion

Copper Contributor

Oct 05, 2018

Solved

Help analyzing data

Can you tell me what type of output this is? I'm happy to search the web about "how to do it", but I don't even know what this is called to do an effective search. I prefer the output in row/column f...

excel

Haytham Amairah
Oct 05, 2018
Hi Bruce,

There is no specific name for such an output!
You can call it whatever you want, like:
Check table
In-stock/Out-of-stock table
To get a table like it, create a unique list contains each clothing type, then place the names of the stores as headers for this table as shown in the below screenshot.

After that, use this formula in cell B2 and copy it down and to the right:
=IF(COUNTIF(Data!A$2:A$7,$A2),"X","")

Please find the attached file
Hope this helps you
In Stock - Out of stock table.xlsx15 KB

Haytham Amairah

Silver Contributor

Oct 05, 2018

Hi Bruce,

There is no specific name for such an output!

You can call it whatever you want, like:

Check table
In-stock/Out-of-stock table

To get a table like it, create a unique list contains each clothing type, then place the names of the stores as headers for this table as shown in the below screenshot.

After that, use this formula in cell B2 and copy it down and to the right:

=IF(COUNTIF(Data!A$2:A$7,$A2),"X","")

Please find the attached file

Hope this helps you

In Stock - Out of stock table.xlsx15 KB