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.