Does anyone know of a way that I can make a formula that analyzes all the data in a loop ahead of time and compiles the loop into one string like : Carcase Left Drawer Box Right Drawer Box Adj Shelf, that way I can analyze the entire string for amount of occurances of "Left Drawer"? Trying to make a function LeftCount = occurances of "Left Drawer" in entire data. So I need this ahead of time before executing the function I'm going to use LeftCount for.