I have a spreadsheet in which the rows are unique individuals with an ID number in column A. There are 79 columns and each may contain one or more drugs that I am searching for (e.g. "morphine" and "baclofen"). I would like to search the spreadsheet for defined words and then express the output as individual ID - drug pairs so that I can see which dugs appear in which individuals rows. I am using excel 2010.
Thanks
JB
Bookmarks