Formulas

How To Fix The Excel Error An Item Name Cannot Be Found, Check That You’ve Typed The Name Correctly And The Item Is Present In The PivotTable Report

Leave a Comment / Formulas / PivotTable

Recently when I add a calculated field in an excel PivotTable, I encounter the error An item name cannot be found, check that you’ve typed the name correctly and the item is present in the PivotTable report. In this article, I will tell you how to fix this error.

How To Use Excel Formula To Add Calculated Field In PivotTable

Leave a Comment / Formulas / PivotTable

In this article, I will tell you how to use excel formulas in a PivotTable to perform calculations and add custom fields to the PivotTable. This is very useful in some use cases.

How To Copy Paste Exact Formula In Excel Without Changing Cell Reference

Leave a Comment / Formulas

When you copy a formula cell and paste it to another cell in excel, it will always change the cell references value in the original formula automatically. For example, suppose cell A1 contains the formula “=B1*C1“. You copy cell A1 and paste the value to cell D1, and you will find the content of cell D1 …

How To Copy Paste Exact Formula In Excel Without Changing Cell Reference Read More »

How To Use Formula To Remove Duplicate Rows In Excel

Leave a Comment / Formulas / COUNTIF, Remove Duplicate

In the previous article, I told you how to use the excel advanced filter and the remove duplicate menu to remove duplicate rows in excel. In this article, I will tell you how to use a formula to filter out duplicate rows in excel and remove them.

How To Automatically Insert Date Time In Excel

Leave a Comment / Formulas / IF, NOW

In the previous article, I told you how to insert the date & time in excel using excel functions or shortcuts manually. In this article, I will tell you how to insert the date & time in one excel cell automatically when you input or update data in another excel cell.

How To Fix Excel Circular Reference Error There Are One Or More Circular References Where A Formula Refers To Its Own Cell Either Directly Or Indirectly

Leave a Comment / Formulas / ERROR

When you input a formula in an excel cell, sometimes you may encounter the excel circular reference error. The error message is there are one or more circular references where a formula refers to its own cell either directly or indirectly. This article will tell you how to fix this error on Excel for Windows …

How To Fix Excel Circular Reference Error There Are One Or More Circular References Where A Formula Refers To Its Own Cell Either Directly Or Indirectly Read More »

How To Insert Date & Time In Excel With Excel Functions Or Shortcuts

Leave a Comment / Formulas / NOW, TODAY

In this article, I will tell you how to insert the current date and time in excel using the excel functions or shortcuts.

How To Sum Dynamic Range In Excel

Leave a Comment / Formulas / INDEX, LOOKUP, MATCH, SUM

The excel SUM function can calculate the summary of number values in a cell range. But when you add a new number cell before or after the cell range, the SUM function can not add the dynamically added number in the result. This article will tell you how to sum dynamic range in excel.

How To Use OFFSET Function In Excel

Leave a Comment / Formulas / OFFSET

The excel OFFSET function can be used to get the reference to a cell or cell range from the starting point ( cell ). It is very useful when you use it correctly. This article will tell you how to use it with some examples.

How To Use Excel HLOOKUP Function With Examples

Leave a Comment / Formulas / HLOOKUP

The excel HLOOKUP function is similar to the VLOOKUP function. It can look up a value in the first row of an excel cell range horizontally. When it finds the matched cell then it will return the cell value in the row specified by the row index number of the cell range. The returned cell …

How To Use Excel HLOOKUP Function With Examples Read More »