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 |
All times are GMT +1. The time now is 12:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com