Thank you!! That works. and my data is from a much larger data set where I am analyzing "at the money" stock options, but "at the money" changes as the stock price changes so I have different option strike prices based on what day I am looking at. The way I set up my workbook was one security i.e Wells Fargo in row 1 and then the different strike prices across the columns. i.e. Wells Fargo strike price 35 = (1), Wells Fargo strike price 36 = (2) and so forth, but on my second sheet I only care about the "At the money" strike, hence the one row compared to multiple columns in the previous worksheet. Does that make sense?