Could anyone give me the formula to look up a range L10:L50, which is pulling data from another list. If there is a duplicate name in the list to show that name as the result (there will only ever be a maximum of two names duplicated)
Could anyone give me the formula to look up a range L10:L50, which is pulling data from another list. If there is a duplicate name in the list to show that name as the result (there will only ever be a maximum of two names duplicated)
It would really help if you were to post a sample. If you could also demonstrate your desired result that would help too.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks