Use The EXACT Function To Force Upper Case Data Entry Into Excel
Hello Excellers, a warm welcome back to another #formulafriday blog post. in my 2019 series. The Excel formula tip today is a recent favorite of mine at the moment, trying to get users to enter...
Formula Friday- Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation
Happy Friday!...time to Excel with another #formulafriday blog post in this series. Today let's take a look at how to prevent duplicate name or employee ID numbers in a worksheet. So, how do we...
Formula Friday – FLOOR Function In Excel- Find Out The Decade That Song Was From
Happy Friday Excellers and welcome to another #formulafriday blog post. I found this little Excel formula out by accident. I was trying to find out what decade a date was from and thought it may...
Hello and welcome to yet another #formulafriday blog post. I want to share today with you an Excel formula problem a colleague of mine asked me to look at a week or so ago. So, I thought it would...
Macro Monday – A Macro To Sort your Excel Sheets Alphabetically By Name
Hello Excellers, I am happy to bring you another Excel Macro Tip today in the #macromonday blog post series. This macro is one that I use a lot at work - Sorting my Excel sheets alphabetically by...
Macro Monday – How To Automatically Lock A Cell After A Value Is Entered
Welcome to another #macromonday blog post in this series. This blog post is in answer to a question sent to me by a subscriber. They wanted to know how to lock a cell once there was a value...