Profile cover photo
Profile photo
B Arvind Kumar
84 followers
84 followers
About
Posts

Post has attachment
Alternative for SUMIF
Ever wondered while using "SUMIF" function, the sum range cannot be more than one column!!  This indeed is a big drawback while using a large data set where you need to sum matching certain conditions. I often end up using multiple sumif with "+" which make...
Alternative for SUMIF
Alternative for SUMIF
blog.arvindkumar.com
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Solving issues with "VLOOKUP"
VLOOKUP syntax We often encounter "#N/A" while using VLOOKUP function to compare two lists. One of the most common problems that give rise to this error is extra spaces either to the end or to the beginning of the string. What's the way out? The simplest wa...
Add a comment...

Post has attachment
Identify duplicate values in a list using "Countif"
Though MS Excel today allows to easily eliminate duplicate values in a list, have you ever tried to identify the number of entries that gets repeated in an excel list? In the above example, we can identify the repeat entries using "COUNTIF" function. Option...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...
Wait while more posts are being loaded