Skip to main content

Posts

Showing posts from March, 2016

New Article

How to SUM by matching partial text in Excel

Hide Slicer items if there is no data

If you have historical data, then it is very much disturbing to select a specific item from your slicer menu from all visible items. To do a better look, you need to hide inactive items while there is no data. How to do it? It is very simple. First select the Slicer items box by clicking on the title. Then go to the Option menu and select Slicer Setting. Image 1: Options | Slicer Settings Choose hide items with no data and click on OK. Image 2: Slicer Settings Slicer with no data has hidden after new settings: Image 3: Slicer with no data has hidden

Get the unique values from a column by using advance filter in Excel

What is unique value? Unique value is a value that occurs only once in a single column. In this article I will let you know how to get the unique values from a list. Many MIS Executives have suffered often while creating a report regarding district wise. And I believe that they think it is very hard to find the unique values from a large list and then to generate the report. How to get unique values through Advance Filter? There are many ways to get the unique values from a list. Array formula, PivotTable, Advance Filter, CountIF function etc. As the title said here I would like to describe how to get it through Advance Filter option. To do this you need to follow the below steps: Step 1: Assume that, you data range is A2:A29. First of all Select the column that contains the duplicate values and set a Filter from Data menu. Image 1: Filter added Step 2: Click on Data » Sort » Filter group » Advanced. This will show a dialog box. Step 3: Select Copy to another loc...