Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by Latest Date
I would like to instruct a macro to filter out everything but the latest date
in a date field. The MonthYr I want to keep is included in the title of the file, if that helps. The overall goal is to string several existing macros together to filter and number the latest monthly metric scores in one list (quickly). 'Suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by Latest Date
An idea to consider: you could add an additional column with the function
RANK([date], [whole range]) and filter with the value 1 in that column. Stephane. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by Latest Date
Stephane: Thank you for responding. I did manage to combine a number of
queries into one and to make it work one time. But, later I received a debug error when I tried to run it a second time. The smaller macros work one at a time, so that is one good thing, anyway. I have a working macro to insert a rank column, another one to start the autofilter, another to number the rank scores in the rank column. What is tricky, and does not seem to work, is to record the steps to filter out all but the latest monthly scores, to sort by those scores and to filter out rows without scores. DOUG "Stephane Quenson" wrote: An idea to consider: you could add an additional column with the function RANK([date], [whole range]) and filter with the value 1 in that column. Stephane. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis date - display beyond latest date. | Charts and Charting in Excel | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
sumproduct for latest date | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions |