insert function

  1. Y

    Index/Match formula working in' Insert Function' Preview, but returns VALUE error on spreadsheet

    Hello, I've been working on an index/match formula on Excel to retrieve a value from a table based on two column criteria. When I do this via the Insert Function tool, it correctly previews the value it should lookup, but once I've clicked OK and returned to the spreadsheet, it returns a...
  2. D

    COUNTA Formula and INSERT Function Help!

    Hi everyone, I am having trouble with my formula. I want to count non-blank cells using the COUNTA function. I want to count non-blank cells in a column in a different workbook. The workbook I want to count from is named "File1.csv" and it is open. If I type in the following formula it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top