Posted inLearn
Learn How to Set Up and Run Solver in VBA for Excel Formula
Solver is an add-in that is provided with Excel and is used to perform ‘what-if’…
Posted inLearn
Excel Tips: Changing or Replacing Cell Names Chronologically
Sometimes, you may want to change or replace the names of multiple cells in a…
Posted inPetroleum Engineering
Cumulative Effective Compressibility (Fetkovich) in Excel
Cumulative effective compressibility Fetkovich is a term that describes how much the volume of a…
Posted inLearn
Counting Cells with Different Conditional Ranges in Excel Formula
Sometimes, you may want to count the number of cells that meet certain criteria in…
Posted inLearn
How to Use Excel Table Search Function for Partial String Match
A partial string match is a way of finding a text value that contains or…
Posted inLearn
Learn How to Update Cell Values with INDEX and MATCH in Excel
Sometimes, you may want to update a cell based on the value of another cell…
Posted inLearn
How to Count Cells in a Month Range in Excel
Sometimes, you may want to count the number of cells that fall within a specific…
Posted inLearn
How to Apply Conditional Formatting Based on Date in Another Cell in Excel
Conditional formatting is a feature in Excel that allows you to change the appearance of…
Posted inLearn
Excel Formula to Return a Date Conditionally
In this article, I will show you how to use a formula to return the…
Posted inLearn
Using Logical Functions to Test Date Conditions in Excel
Sometimes, you may want to check if a date in one column of an Excel…