Articles: All Listings RSS

Filter listings...
http://www.techrepublic.com/blog/windows-and-office/a-quick-trick-for-hiding-duplicate-excel-values/

www.techrepublic.com/blog/windows-and-office/a-quick-trick-f...

Duplicate values aren't wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel.

Visited117
http://blogs.technet.com/b/kclemson/archive/2004/04/12/112001.aspx

blogs.technet.com/b/kclemson/archive/2004/04/12/112001.aspx

If you have data in Excel and you want to hide rows with duplicate entries, it's super easy. Read these instructions.

Visited104
http://www.excel-easy.com/examples/remove-duplicates.html

www.excel-easy.com/examples/remove-duplicates.html

This example teaches you how to remove duplicates in Excel. Click any single cell inside the data set. On the Data tab, click Remove Duplicates.

Visited137
http://www.tech-recipes.com/rx/2928/excel_2007_how_to_hide_duplicate_records_in_a_spreadsheet/

www.tech-recipes.com/rx/2928/excel_2007_how_to_hide_duplicat...

If you have a large spreadsheet that contains duplicate entries (customer names, class subjects, etc.) and you want to view only the unique records in the list, you can filter out the duplicates.

Visited81
http://www.extendoffice.com/documents/excel/544-excel-remove-duplicate-rows.html

www.extendoffice.com/documents/excel/544-excel-remove-duplic...

Most of you may meet a difficulty that there are many duplicate rows in your worksheet, and you need to remove them and just keep the unique rows. In this case, how can you get the duplicate rows removed quickly? This article will introduce some easy w ...

Visited96
https://www.youtube.com/watch?v=wfcM0Vi8nWY

www.youtube.com/watch?v=wfcM0Vi8nWY

It is almost inevitable that - over time - duplicate records will creep into your Excel data set. In this tutorial, I demonstrate 3 methds to help you to identify and then either edit or delete the duplicate records.

Visited215
https://www.youtube.com/watch?v=AZ74TPlbuug

www.youtube.com/watch?v=AZ74TPlbuug

In a sorted table, hide duplicate entries, showing only the first entry.

Visited225
https://www.youtube.com/watch?v=LCARvtUs280

www.youtube.com/watch?v=LCARvtUs280

Learn how to remove or hide duplicate data and display only the unique records in excel

Visited131
http://www.extendoffice.com/documents/excel/2721-excel-hide-duplicates.html

www.extendoffice.com/documents/excel/2721-excel-hide-duplica...

Sometimes you may need to hide all duplicates and keep the unique values for columns in Excel. In this article, we will show you methods of hiding all duplicates including/excluding the first one in Excel.

Visited80
http://www.pcmag.com/article2/0,2817,1978541,00.asp

www.pcmag.com/article2/0,2817,1978541,00.asp

In Excel, how do I delete rows that are duplicates—that is, rows that match in multiple columns like Last Name, First Name, House Number, and Street Name?

Visited145
http://www.addictivetips.com/windows-tips/excel-2010-remove-delete-duplicate-rows/

www.addictivetips.com/windows-tips/excel-2010-remove-delete-...

Microsoft has made it quicker to remove duplicate rows in Excel 2010, all it takes now is two simple steps. The best part is that you don’t need to select any specific row before removing the duplicate rows, the build-in Remove Duplicate feature ...

Visited215
http://www.mbaexcel.com/excel/how-to-remove-duplicate-values-in-excel/

www.mbaexcel.com/excel/how-to-remove-duplicate-values-in-exc...

For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values. Some people refer to this process as de-duping. The main reason this is necessary in data ...

Visited109
http://www.exceltrick.com/how_to/find-and-delete-duplicates-in-excel/

www.exceltrick.com/how_to/find-and-delete-duplicates-in-exce...

While working with huge data tables in Excel there are times when your data may contain duplicate records. To eliminate the confusions that duplicate records may result into and to avoid unnecessary increase in physical size of the spreadsheet it is be ...

Visited92
http://www.computerforall.ca/microsoft-office/87-office-2013/excel-2013/206-how-to-remove-duplicate-values-in-microsoft-excel-2013

www.computerforall.ca/microsoft-office/87-office-2013/excel-...

Computer for all is the best place to learn Microsoft office especially Microsoft Office 2013 and Microsoft Office 365 and their news features, tips and templates.

Visited158
https://social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45-806f-9a42258bdb5f/how-to-open-two-excel-files-in-multiple-monitors-in-windows-7?forum=excel

social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45...

How to open two excel files in two excel windows using multiple monitors in Windows 7.
Currently it opens multiple files on top of each other on the same one monitor.

Visited116
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/i-want-to-open-2-excel-files-in-separate-windows/f7588d9a-3c41-466f-8f01-3b6ab9661ae3

answers.microsoft.com/en-us/office/forum/office_2010-excel/i...

I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window.

Visited206
http://stackoverflow.com/questions/20986436/hiding-rows-in-excel-based-on-words-in-a-cell

stackoverflow.com/questions/20986436/hiding-rows-in-excel-ba...

I am VERY new at VBA and have been searching for VBA code that can do what I want. I have tried several and attempted to adapt them however I just can't seem to get them right so thought I would try for some help!

Visited87
http://stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a-row-or-column-in-excel-without-using-vba

stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a...

I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to kno ...

Visited105
http://www.mrexcel.com/forum/excel-questions/550371-hide-rows-based-formula-result.html

www.mrexcel.com/forum/excel-questions/550371-hide-rows-based...

I dont know much about VBA but can anyone help? I need a macro that will hide all rows where the formula result is zero as a result of the cost centre selected from a validation list?

Visited74
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/automatically-hide-rows-in-excel-based-on-value/17036d97-a5c9-42a2-9f2d-f53d53510da7

answers.microsoft.com/en-us/office/forum/office_2010-excel/a...

I have to develop an excelsheet where a row is hidden automatically if the value in cell e is 1 and unhide the row automatically if the value in cell e is 2. And this has to work for all rows.

Visited147