Jun 27, 2019 | Excel, Excel General
Believe or not, I have encountered this problem quiet many times – “How to get the count of unique items from a column from a table that has duplicate records or has multiple layers.In this tutorial I will show you how to use an array formula to get the...
Jun 3, 2019 | Excel, Excel General
In general, when you hide rows or columns or rows and columns, and you are trying to copy just the visible cells in your table to somewhere else, instead of copy just the visible cells on your table, Excel is going to copy everything.In this tutorial I will be showing...
May 2, 2019 | Excel, Excel General
In Excel, you can insert different symbols using the Webdings, Wingdings font styles. But a major drawback using those font styles is, if a user change the font style to something else, the symbol will then disappear. In this tutorial, I will show you an elegant way...
Apr 26, 2019 | Excel, Excel General
When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc). In this...
Apr 19, 2019 | Excel, Excel General
As we all know, Excel is a very useful application that has many features. You can use Excel to do things like a building a database, a data entry sheet, creating pivot table and more. Because there are way too many features in Excel sometimes it can get a little bit...
