Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find latest effective month and delete others
I have downloaded out of our system the beginning of an operation that has proved to be very challenging already.
For a group of Properties/Wells in the State of Oklahoma, I have downloaded all the lists of owners that have royalty interests for these properties. Right now, I have about 26,000 owner records, and there are roughly 500 properties that contain these owners. The property number is listed on each of these property records as well as the effective year and month as detailed in the next paragraph. Each owner's records contains a field that contains an effective year and month expressed in numeric format for example 201001 meaning January 2010. The operation is to come up with the most recent list of ownership by well using the field Effective year and month(the aforementioned numeric field listed in the previous paragraph), extracted to a separate listing on a separate tab. I don't want to have to do this well by well. I appreciate your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find latest effective month and delete others
Have you tried doing a descending order Sort using your yearmonth field
as the sort key? -- - Garry Free Usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find latest effective month and delete others
Yes, I can do the sort the way you described, but you have to be able to copy out just the records with the latest Yearmonth within each Divord... That is what I am not able to figure out is that part
Have you tried doing a descending order Sort using your yearmonth field as the sort key? -- - Garry Free Usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find latest effective month and delete others
After you Sort you can Filter on just the latest, then copy/paste.
If you want to use a macro then just turn on the macro recorder and go through the steps manually once, then turn of the macro recorder and save the macro for future use. -- - Garry Free Usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Day of the Latest Month Syntax problem | Excel Programming | |||
Formula for Latest Entry For Each Month | Excel Discussion (Misc queries) | |||
Summation of latest running 3 month total | Excel Programming | |||
Latest running 3 month total | Excel Programming | |||
get the latest day of the previous month | Excel Discussion (Misc queries) |