Report Offensive Message

Unstable
I know this works, but I don't know why. This seems to be counting the number of lists that are in list, which should be one. Why does Excel interpret the first "list" as the list, but the second "list" as the current cell?
=MIN(IF(COUNTIF(list,list)>1,list,""))=A1
Posted by jeffpattersonis
16th May 2012