Thread: [Solved] Advanced Filter is leaving out some columns
View Single Post
 
Old 03-13-2016, 03:54 AM
Rod_Bowyer Rod_Bowyer is offline Windows 10 Office 2007
Novice
  
Join Date: Mar 2016
Posts: 12
Rod_Bowyer is on a distinguished road
Default
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.
Reply With Quote