The other day, I wanted to use the filter for unique feature in Excel to get a list of unique items.
So I got my data ready and started the process.
Two clicks into it, Excel poops out this message stating that it can’t determine which row contains column labels.
As far as I can tell, this means that Excel can’t discern which value is the column header. By the way, I get this message whether I select the entire column or just the range.
Apparently, if your data is formatted all the same, Excel refuses to assume that the first row is the header.
In my case, I’d have to give PM Mangager Name (my header row) an explicitly different formatting. It doesn’t matter which formatting. I can: make the font bigger than the rest of the rows, apply bold, change the color, etc. It doesn’t matter; I just need to apply some distinguishing format difference.
Now I’ve been trying to think of what exactly Excel is protecting me against.
Why would it need to know which row is the header row?
This feature doesn’t sort the data, so there is no chance of the header being moved from its original position.
If I’m filtering for unique values, wouldn’t the header be a unique value, thus included in the output?
In any case, the message states that I can press OK to designate the first row as the header.
So after all that hub-bub, all I need to do is press OK to tag the first row in the range as the column header.
Can anyone think of a good reason for this message?
Also, who here thinks that I need to get a life and focus my impotent rage elsewhere?