How to filter out rows with duplicate content in Excel

re: How to filter out rows with duplicate content in Excel

Jason — Tue, 13 Apr 2004 13:53:00 GMT

That is the most amazing Excel tip ever! Thank you, thank you, thank you. Who knew it was there all along?

--jason

re: How to filter out rows with duplicate content in Excel

KC Lemson — Tue, 13 Apr 2004 16:10:00 GMT

Jason: Comments like yours make this so worthwhile :-) Thanks.

re: How to filter out rows with duplicate content in Excel

John Eddy — Tue, 13 Apr 2004 19:06:00 GMT

Another cool trick:

If you want to do a quick count/sum/avg of some numbers, simply select them and look in the lower right at the status bar. If you don't want whatever its showing you (eg, it shows you sum and you want avg, right click it)

re: How to filter out rows with duplicate content in Excel

KC Lemson — Wed, 14 Apr 2004 04:13:00 GMT

John: Way ahead of you, man: http://blogs.msdn.com/kclemson/archive/2003/10/24/53879.aspx

;-)

re: How to filter out rows with duplicate content in Excel

John Eddy — Wed, 14 Apr 2004 14:55:00 GMT

Oh monkey pants.

re: How to filter out rows with duplicate content in Excel

Cindy — Wed, 09 Jun 2004 20:15:00 GMT

Did not know you could do that,.....thanks much

Filtering Out Duplicate Rows In Excel

Opinions of the Wolf — Wed, 01 Sep 2004 04:12:00 GMT

This blog entry on eliminating duplicate rows in Excel has changed my life... thank you, earnest looking Microsoft employee! Now why the fuck isn't this in the help menu anywhere? I'm looking at you, Clippy....