Advanced Filter is leaving out some columns

[Rod_Bowyer]

I have a fairly simple spreadsheet with data in columns A to G down to row 27 (with Data starting in row 4 - headings to allow room for my filter criteria). My Column headings are Date, Position, Box Number, Time, Distance, Track and Grade (yes I am trying to analyse Greyhounds).
When I apply an advanced filter to select the most recent 12 entries I have the formula =IF(LARGE($A$5:$A$27,12)<(LARGE($A$5:$A$27,13)),1, 0) pasted in cell A2 in the criteria area (A1:G2). My filter area is A4:G27 - which included my headings. The headings are also in cells A1:G1 - in my criteria area.
The filter works beautifully when I select "filter the list, in place" - but the last two columns are both blank - none of the data in those columns and in those rows appears in the filter result - even though the columns are in the criteria range. Very frustrating but I simple do not understand it.
When I try to filter to another location all I get are the column headings with no data in any of the rows. Very strange. Any help would be greatly appreciated.

[Rod_Bowyer]

Ok, now I feel plain silly. The advanced filter is working fine - it is just filtering out all my records and bringing up data underneath the filter criteria which does not have any data in the last two columns.
So, basically my filter formula for identifying the last 12 entries is not working so I would appreciate any help.

[xor]

It would be easier to help if you upload the file.

[Rod_Bowyer]

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.