Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count of dishes that contain specific ingredients
Hi,
I have a table in excel where the first column is dishes and every subsequent column is ingredients ------------------------------------------------------ dishes | ingredients | ingredients | ingredients -------------------------------------------------------------------- dish 1 apple corn meat dish 2 salt apple fish dish 3 meat grain corn dish x w y z -------------------------------------------------------- I would like to translate the result into another excel file in the following format: item | # of dishes that is using ingredient | dish 1 | dish 2 | dish 3 | dish x ----------------------------------------------------------------------------------------------------------- apple 2 x x corn 2 x x salt 1 x meat 2 x x fish 1 x Is there a way to do this without using VBA code? Thanks :D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Count a Specific Value in a Row | Excel Discussion (Misc queries) | |||
Count Specific Item in Specific Row | Excel Discussion (Misc queries) | |||
Count Specific word in Specific range | Excel Programming | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
Count If Specific word in specific range | Excel Discussion (Misc queries) |