ok in BE1:BK92 i will have any where from 1-10 names entered but they will be duplicated anywhere from 1-100 times. i would like to enter a formula in a cell that will look at BE1:BK192 and remove all the duplicates and tell me the 1-10 names. BE1:BK192 is all information gathered from other worksheets. thanks,
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
If you upload a sample, I can probably put something together for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
here is what Im working with, I hope this helps
Please see attached.
unique.xlsx
ok look at this one it is on the misc tab. i couldnt get your formula to work on my actual sheet. sorry and thanks for all your help
MISC tab has only 0 values in columns BE & BF
Maybe if you provided a few sample answers, and how you arrived at them? You dont really have much data to play with there, either?
the names are coming from MONDAY-SUNDAY tabs i just put in random names in random cells to see if it would work. what RobertMika put together seems likeit would work just needed to change it to work on the actual sheet.
I repeat after Ford:
Provide data with desired result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks