Row Number for Duplicates in Excel VBA
Recently I came across a situation to find the row number for duplicate values.
In SQL Server there is a inbuilt function ROW_NUMBER() read more but in Excel there is no direct function as such.
Category: Excel
Conditional Formatting on Errors in Excel
Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.
Achieving Optimal Use of Shelf Space through Linear Programming
Your Product Sales is Affected by Shelf Space?
Did you notice that every time you go to a supermarket to buy something, you notice the middle shelf before the top and bottom shelves. This is contradictory to the typical sequential behavior where we like to start from one end and end at another. Of course, many a times we start from one end of the market and go around to the other end but each time we start from one of the shelves which usually is the middle one. Read more
How to Create your first Pivot Tables in 5 minutes (or less!)
Pivot tables are one of the most notable features of Microsoft Excel. And it’s easy to see why once you are familiar with the feature. To a beginner, they may seem a bit mysterious or intimidating. But once you learn a few basics to get started, you will be well on your way to visualizing your data in new and useful ways.
Learn MS Excel from Excel guide
Hello friends! Recently I came accross with an MS Excel guide which contains almost all the MS Excel functions. I am not sure about the author/source but it’s an excellent guide to self Excel learning.
Read more
Tic Tac Toe in Excel using VBA
Hello friends! I was playing with VBA and create this Tic Tac Toe game in Excel. Comment if you want to learn how to create how to create Tic Tac Toe in Excel using VBA.
Advanced Table in Excel using VBA
Hello friends! Today we’ll be learning about the Advanced Table in Excel using VBA. This post will be very using useful. Advanced Table in excel is very useful in many cases and also to replace pivot table in Excel.
Interactive Dashboard in MS Excel
Hello friends! this is a post after a long time. Recently I started learning Excel-VBA and I’ve created an Interactive dashboard in excel. I got the inspiration from here. It doesn’t have much use of VBA for that I’ll post tutorials.
I am also attaching the Excel file to reuse and interact with it.