In sheet one, here is a general list but some of the Items or names are twice, I would like to find out a separate list in sheet two along with all information which are in the same rows, from those Items or names which come twice in sheet one.
Looking for a formula, that salve the above problem,
Thanks,
Wafa