Hi there.
I would like to extract a unique list of values from column D and have the unique list appear starting in H8. I would also like the list to be alphabetized.
Workbook: Book1.xlsx
Thanks in advance for your help!
Hi there.
I would like to extract a unique list of values from column D and have the unique list appear starting in H8. I would also like the list to be alphabetized.
Workbook: Book1.xlsx
Thanks in advance for your help!
Open to using a pivot table??
Life's a spreadsheet, Excel!
Say thanks, Click *
Take a look to this.
http://www.get-digital-help.com/2010...anks-in-excel/
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Please see attached file:
You can hide column I as the range in the formula will adjust dynamically and so will in H9
Last edited by AlKey; 01-08-2014 at 04:50 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
hi,
in this file, what would be the formula if I need to get the unique count of names per day?
Thanks,
Amor
Amorluisa, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
Thanks,
Actually I dont know where to post my question
How to create a new thread
Once you click on www.excelforum.com which is the home page, you will see many subforums listed there. Click on the subforum relevant to your question. It will open up the page containing all the threads created in that subforum. On the top of the page, you will see a blue button called "+Post New Thread". Click on that button and proceed.
Thanks, got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks