Author: Pushpendu Roy Karmakar
Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#140: Color cells if cell value found in another column – Conditional formatting
Here I will make a formula in Conditional Formatting. This formula will color cells if the cell value is found in another column. For example, I am showing this picture below. If the value is present in column A then …
Lesson#140: Color cells if cell value found in another column – Conditional formatting Read more →
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable
We have discussed working with PivotTable in previous lessons. Here I am going to share a small tip about GETPIVOTDATA in PivotTable. How to get rid of GETPIVOTDATA in PivotTable. When we are making some calculations on the Pivot data …
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable Read more →
Lesson#138: How to recover unsaved files in Excel
Sometimes when we work in excel we forget to save the file and we exit excel. But it is possible to recover the last unsaved file very easily if needed. Here I will show you the way. How to recover …
Lesson#138: How to recover unsaved files in Excel Read more →
Lesson#137: How to count any character in a text in Excel
Now I will show you to make a formula that can count any specific character or characters in a text. This means if I write a “Banana” then this formula can count how many “a” is in that text. So …
Lesson#137: How to count any character in a text in Excel Read more →
Lesson#136: Learn how to Remove Duplicates works
Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In this post, you will learn how to Remove Duplicates in Excel works and when and why to use them. See the above picture I …
Lesson#136: Learn how to Remove Duplicates works Read more →
Lesson#135: MAXIF and MINIF with function IF
In this post, I will show you to make two new functions. These are functions MAXIF and MINIF. It means this formula will show the Maximum or the Minimum value when the criteria will be matched. Here I have put …
Lesson#134: Excel errors and why it shows
We know about errors in excel. We face different types of errors when working in excel. Today I will discuss different types of errors and why it shows. What is #DIV/0! in Excel? Its meaning is division by zero. When …