Creating Top 10 List Without Pivot Table
There can be times that you need to create top 10 lists that can be filtered independently from other worksheets along with many other tables...
There can be times that you need to create top 10 lists that can be filtered independently from other worksheets along with many other tables...
When you need to find second largest value or third smallest value in an array of cells, you can do it easily with LARGE() and...
If you need to extract text from string in Excel with a known character, there is an easy way of doing this with just one...
Subtotal function is a versatile function that can answer a lot of your needs all by itself. Besides it has some cool tricks in its...
Datedif Function is used for calculating difference between two dates. I shows the results in days, months or years. Interesting thing is, Datedif Function is...
Here is a quick tip for summing values from different sheets. With this very powerful sum function, you can get totals of different sheets in...