KB: All Listings RSS

Filter listings...
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.mbaexcel.com/

www.mbaexcel.com

Excel, MBA, and Consulting tips from a UCLA Anderson Graduate. There is not that many Excel articles but there is new content.

Visited141
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.exceltrick.com/

www.exceltrick.com

Exceltrick.com is your one stop shop to learn all excel tricks, formulas, chartings & shortcuts. The goal of this site is to make you an excel geek.

Category:Excel
Visited164
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
http://www.computerforall.ca/

www.computerforall.ca

Computer For All Best Place for to learn Microsoft office, Microsoft Excel, Microsoft Word, Microsoft PowerPoint.

Visited75
http://www.excel-easy.com/

www.excel-easy.com

Want to learn Excel quickly? Looking for a fully illustrated Excel tutorial? Using Excel 2007, 2010 or 2013? Looking for easy examples?

We offer a tutorial (Introduction, Basics, Functions, Data Analysis and VBA) on how to use Excel. Below you ...

Category:Excel
Visited81
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
http://excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.html

excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.htm...

This tip contains a macro to hide rows that contain data you don't want to see. (Tips.Net)

 

Visited173
https://social.technet.microsoft.com/Forums/office/en-US/ee76d08d-3306-406d-894c-16fd3cb824d9/each-workbook-in-separate-windows-excel-2010-windows-7?forum=excel

social.technet.microsoft.com/Forums/office/en-US/ee76d08d-33...

A useful thread but my favourite solution is:

  1. Find excel.exe
  2. Create shortcut to excel.exe on desktop
  3. Drag and drop excel files on shortcut
  4. Voila, multiple instance of excel.exe and all file remain visible...

    Visited132