Forum Discussion

Bruce Smith's avatar
Bruce Smith
Copper Contributor
Oct 06, 2018

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 form rather than a chart/graph, as the data will be exported to a publishing program.

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Oct 06, 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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 06, 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