Advanced Filter is leaving out some columns

		Microsoft Office Forums > Microsoft Excel > Excel
Advanced Filter is leaving out some columns

FAQ

Thread Tools

Display Modes

03-13-2016, 03:54 AM

Rod_Bowyer Rod_Bowyer is offline

Windows 10 Advanced Filter is leaving out some columns

Office 2007

Novice

Join Date: Mar 2016

Posts: 12

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.