Originally Posted by Tark
yeah you are understanding correctly... but in my example i only have 450 employees in reality it's 58000 line and 800 employee... too long!
if that is the case, the autofilter function should work assuming that all your entries for first and last name are the same and in the same column.
if you have the first and last name in different columns then use the sort function for the two columns the names are in then just highlight every name thats the same and have xcel count it for you.
Originally Posted by jclau00
pivot table y0
that could work but you would have to explain it to him