Hide All Columns That Contain A Value In A Cell
The following macro will hide all the column containing the word “hide” in each cell in row 1. Here is a brief description of how the code works:
Recent posts
Convert Numbers Stored As Text When Using A Formula
There are a few ways to convert Numbers stored as Text using Formula. You can use: =VALUE() or =NUMBERVALUE() for floating point Numbers. =INT() if you ...
Calculate Sales Commission With Vlookup Sale Amount Tiers
Learn how to calculate commissions for a basic tiered plan and rate table using the VLOOKUP function.
Formula To Get File And Folder Names
Let’s image that the following path is in A1: C:\Users\foo\Documents\parent.folder\foo.bar.txt
Text Values Strings Words And Phrases
Convert text to lower case Example: =LOWER("hello") Result: hello