CategoryBlog

How to count unique values using a formula in excel

H

Count unique vales Yes…you can count unique vales using a formula. This is often comes handy when you are looking for unique sales rep names in your commission file. Or maybe while reviewing sales file with large number of products. Count unique vales using a formula: For this tutorial I’m going to use Excel COUNTIFS formula hence it’s important to understand this formula first...

LibreOffice Calc: The finest alternative to MS Excel

L

There is an MS excel alternative… …Its very nice, powerful, and moreover its free Just a few days back I had some issues with my office installation. I have tried uninstalling and reinstalling but didn’t work. I was so frustrated so desperately started looking for an excel alternative (you can understand my frustration) Just started googling with a search phrase ‘best...

11 Tips to Reduce Excel file size by at least 20%

1

How do I reduce excel file size? The most often asked question. Well, in this step by step tutorial I’ll walk you through various best practices to reduce excel file size and how to optimize excel workbook to work better. #1 Save your workbooks in a Binary format This is my favorite tip and it always works great. I have been recommending this tip since I started writing this...

FastComet Hosting Review: 21 Reasons Why You Should Buy

F

Let me get it right.. This is not my regular excel tutorial instead this is a FastComet hosting review — “and of course this is not a paid review – in fact, this website is also hosted with them”¬† In general, this is how it starts… One fine day you come up with an idea to open a website/blog and write about your favourite¬†topic. Then, the process starts like this...