Skip to main content

TIP - 39 : Indirect function - used to avoid ref error


Indirect function - used to avoid ref error

When we deleted a data in cell or range of cells, then we the formula linked with that cells will shows the error which is called reference error (#REF!).

Through this trick we can avoid those errors -

Please use the formula =Indirect (ref_text)

Just type the cell reference of particular cell in double quotations

Examples: = Indirect(“A2”)





Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more