Generic column headings when using advanced filtering in Excel.
Posted on 2011-03-13
This is a follow-up question from another thread.
In Excel (2007), I have recently been using advanced filtering more and more as I have learned more about its benefits and advantages. However, one thing that has messed me up on occasion is the requirement to have column headings in row 1 followed by a criteria area in some number of rows (say rows 2-4) followed by a duplicate of row 1 which in this case would be in row 5.
Because I almost always use two rows for headings and frequently insert, delete, and change columns -- sometimes without assigning or changing headings, I decided to just keep "my headings" (i.e. those I would normally have in rows 1 & 2 and which pertain to my spreadsheet) in row 6 & 7 and use generic headings in row 1 & 5. For the generic headings, I arbitrarily chose to simply use the actual letter(s)-heading of that column. Thus, my previous question related to getting the actual letters since =COLUMN() returns numbers.
It was suggested by an expert that I explain the purpose behind my previous question on the chance that a better solution may exist.