Can command Advanved Filter do without selecting header(i.e. just process cells)?
I'm using the command Advanved Filter to filter out duplicate data entries quite frequently and it pains me to every stipulate the header for a row of data as the program asks to do. Yet sometimes it(Excel) goes about this filtering business without pestering me about its need for a header. And does it without fault (the first row is included in the data to be filtered and is not treated as a header). So I'm asking those more experienced - is it possible to 'tell' the program to never ask me for a header when Advanced Filtering and always treat the first row as a header?
|