I am posting some data records from an Invoice worksheet to a table in a SalesData worksheet with VBA. All of the formulas seem to calculate except for this one, =(COUNTIF(H$8:H65,H65)=1)*1, the formula should produce a 1 if the new record's customer's name is unique (new). H$8:h65 is the range of customer names. I then use the 1 in a third worksheet to generate a customer list of unique names. If I manually input a new record with an unique customer name the cell calculates properly.