I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF to filter to my duplicates then pulling based on other filters; however, the COUNTIF seems to be hanging up excel. I've outlined my process below.

- Create column with =COUNTIF(A:A,A2)
- Copy formula down the column
- Save worksheet (Hangs/takes ages to finish) or Copy column and paste values (Hangs/takes ages to finish

I have done this in Excel 2010 and 2013 with the same results on two different PCs. The worksheet only has 172000 lines in it. The formula executes fine to get the values, but hangs when I try to save or to copy and paste the column values. Without that column, the worksheet behaves normally. I've never encountered this before.

Thanks in advance!

COUNTIFS()rather thanCOUNTIF().........restrict the range using$A$1:$A$17200012more comments