VBA: Create unique list based on latest entry in list

I have a sheet which has 3 cols of data. Lotid, Yield(Yld), Test_date.

For any given "date" I only have a single lotid. HOwever, i want to generate a list of
lot-ids and their yield with the latest test date.

See enclosed file......i try to show an example.

I am trying to do this in VBA........

welchs101,

Here's a macro solution. I have attached a modified version of your sample file so you can see how it works.

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

thanks, both instances (in vba and out) are helpful. thanks.

I was wanting to do this in vba as i am reading the file in via vba and i wanted to keep all the "work" in vba but its nice to know i can do this outside vba as well. So thanks.

fyi: when i click on the get data button the macro has some issues running but if i go into the code and run it from there it works..........as i was hoping it would so thanks!!!!!!!!!!

Every time i someone posts their soln i learn ALOT! Not only do i learn how to do what i was asking about but i learn different ways to do things. So thanks.

As i am going through the code i am realizing that it works great. However, for my situation it may not. When i created the test file for the "excel forum" only put 3 of the cols of data. In fact there are about 30 cols of data in addition to the 3 i showed. For the code to work i would need to create an array for each col.

What i was wondering is instead of using the arrays as they are in the code if some how we could just delete the row which has the lesser date. Does this make sense? Any ideas?

Note: I really like the code. Took me a while to go through it. I have some other questions abou the previously posted code which i will start another thread for.....really cool!

welchs101,

I updated the code to only use two arrays. The beginning data only needs the start column, end column, and date column:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

thanks i will check it out.