This works perfectly fine!! Thanks a bunch! How does it work though-in plain terms? Are you checking to see if the count of similar values in column A and negative values in column C are both 1 and if so, the value of column A is displayed?