Mar 06 2020 08:00 AM - edited Mar 06 2020 08:15 AM
Goal: I need to FILTER Data Records starting in row #3
I have a table with 2 header rows (see image attached): {Row#1 & Row#2). i.e. my dataset records actually start in Row#3.
ISSUE: When I insert the FILTER button into a single column in Row#2, Excel defaults back, and forces the Filter Button into Row#1 (NOT DESIRED).
Excel 2020 (latest desktop version)
Mar 06 2020 08:13 AM
resolved? // It appears that I can not insert a 'single' Filter button into Row #2 column, however, I can overcome this limitation by selecting the entire row then activating the FILTER button in all columns.
not a big deal ;)