VBA Code to Count Cells by Color
VBA TRICKS

VBA Code to Count Cells by Color

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

Read More
VBA Code to Sum Cells by Color
VBA TRICKS

VBA Code to Sum Cells by Color

Recently some of our subscribers have requested us to share a VBA code that can sum the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to sum the cells with specific color and returns the total sum of the matching color cells

Read More
EXCEL TRICKS

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use this amazing excel formula to remove these spaces: Excel Formula: =Trim(text)   Below is an …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn