Hello All,

Excel newbie here and have a question in regards to data extraction without using the built in autofilter from excel. I should also mention that I am using Excel 2007.

Given a column A of data, I want to make a new column B with the data from A that meet a certain criteria. It sounds pretty simple yet it makes me want to kick my computer since I cannot figure it out. Here is what I have written and I receive a #NUM! error:
A is the column of data, B is the extracted Data, A12 is the Count of how many met criteria. C2 is the Criteria Value.

HTML Code: