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
Please post an example file which reflects your situation so we have something to work with.
Are you implying that you need a list of all items that have synonymous names? If yes, how can the formula identify whether it is synonymous?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks