


COUNTBLANK Formula in Excel
How to Use the COUNTBLANK Formula in Excel The COUNTBLANK formula in Excel is used to count the blank cells within a selected range. Depending on the analysis that you’re performing, this could come in handy as you do not have to manually Formula explanation: • Range:...
FORMULA TEXT function in Excel
How to Use the FORMULA TEXT function in Excel The Formula TEXT function in Excel is used to return a formula as text. If you have got a string of formula that is used as an equation within a cell, you can use the formula text formula and it will actually write out...
VLOOKUP Formula in Excel
How to Use the VLOOKUP Formula in Excel When you have a specific item you’d like to lookup in a table and there is only one of that item in the table i.e. it is unique. This uses a vertical lookup. Separately, you could use the HLOOKUP formula but the HLOOKUP...