Hi,
Sadly this does not work, I have copied the formula and have put in 3 duplicates to test, not a duplicate gets listed as a number 1 and duplicates get listed as a 2 if they are a cell apart (i.e. on ontop of the other) if not they are represented by a 0.
Am i going wrong somewere?
Im using excel 2003, the data is A:1 to A:1000 it can be located anywere in this stacking...