Hello:
Please refer to attached file.
Go to Sheet3.
I need VB Code to find the unique names from column D for Date in G1.
Once found, paste the unique list in ascending order for date in G1 at Q8
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
Go to Sheet3.
I need VB Code to find the unique names from column D for Date in G1.
Once found, paste the unique list in ascending order for date in G1 at Q8
Let me know if you have any questions.
Thanks.
Riz
Hi Riz,
maybe so
Please Login or Register to view this content.
Hello Nilem:
Please refer to attached file.
I have changed the sheet very little.
The results i am getting is not correct.
Need Unique names only...please have a look and help me correct the code accordingly.
Let me know if you have any questions.
Thanks.
Riz
Oh, I thought about the unique, but forgot to write
Please Login or Register to view this content.
Last edited by nilem; 07-17-2016 at 04:25 PM.
Hi Nilem:
Seems to work great.
I like to make small modification.
I would like to ignore "ETMC Abondoned" and "ETMC GrandTotal" from the list.
Can you help code so that these 2 are not included in list.
Thanks
Riz
Try this:I would like to ignore "ETMC Abondoned" and "ETMC GrandTotal" from the list.
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Totally different method
Still no response from you.Please Login or Register to view this content.
http://www.excelforum.com/excel-prog...ange-data.html
http://www.excelforum.com/excel-prog...s-of-data.html
Last edited by jindon; 07-17-2016 at 11:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks