|
|
|
|
#1
03-13-2016, 03:54 AM
|
|||
|
|||
Thanks for that but I think that I have solved the problem. I have put a formula - =LARGE(A1:A27,12) in the first row of the selection criteria under the Date field and then LARGE(A1:A27,11) in the next row and so on and it now works beautifully and extracts all columns for the most recent 12 entries. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Filter 2 columns between 2 dates
|
s_samira_21 | Excel | 2 | 02-08-2015 10:34 PM |
|
Advanced Filter - Copy matching records in two worksheets
|
morgantobin | Excel | 1 | 03-29-2013 03:58 AM |
| Macro for Advanced Filter | atwood121 | Excel Programming | 0 | 05-22-2012 07:47 PM |
|
Advanced Filter - Comparing Two Columns
|
apolloman | Excel | 5 | 07-27-2011 04:54 AM |
|
could you help me help me with advanced filter
|
Nora | Excel | 1 | 05-15-2009 11:10 AM |
Windows 10 
Office 2007
Hybrid Mode