View Single Post
 
Old 05-06-2015, 11:29 AM
derohanes derohanes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default

The attached file has three formulae in SHEET1. SHEET2 has a list of ingredients in column A. I want to look in the formulae in SHEET1 for the value in that is in column A of SHEET2 and place the number of occurances in column B in sheet two. So, the expression in the cell SHEET2!B1 should contain the number of times "EPA" shows up in SHEET1. I can't figure out how to write an expression that will take the string in column A and use it for the search, rather than me typing it in.
Attached Files
File Type: xlsx Formulae.xlsx (8.9 KB, 13 views)
Reply With Quote