I'm looking for a formula that will search the workbook each time text is
entered into a certain range of cells, and if it is unique (or first
occurence) it will place the text in a sheet for use in totals.