Slicers to Tables

Do you know that now slicers can be created even with tables.

What is a slicer, in a group of data if you want slice and see a filtered data, you use slicer.

How to use

a)      Create a data Sample

b)      Make that as a table

c)      You will find it in Insert Tab > Table

d)      After the table is done(ensure headers are there)

e)      Place the cursor on the Table and insert slicer(see at the last of the image), select the required fields

f)       You will now be able to slice and see the information.

How to Get count of Unique Data

Here is the formula, you can get the count of unique numbers in a given data

 

If the data is numbers :

=SUM(IF(FREQUENCY(D6:D44,D6:D44)>0,1))

 

If the data is Text :

=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1))

ATO 2014 Feed Back

Hi,

How did you enjoy the ATO 2014. Here is the blog, i have created for you all to share your views and comments.....

Venu

Find Last Record

Do you know if you have to find the last record value in a column

a)      Use CountA(column)

a.      It would give the number of items in that column

b)      Use offset Function

a.      Use the Offset refering to row increment of the above value