The duplicates can occur within each list (column) and also across the numerous lists (columns)
I did try and put all lists in one column, sort the list and then do an IF formula to pull out duplicates, the only issue with this that it screwed up my lists..