self-referencing

  1. D

    Manual Self Referential Column inventory update

    Hey, I'm trying to track inventory amounts and I have multiple sheets using different amounts of each ingredient, and I want one production run to update the total inventory amounts. The trouble is this creates a self referential sequence. Total - Used Amount (Different values depending on...
  2. D

    lookup initial entry in multiple transfers

    Hi, I have two columns with Entry no and TRansferred from entry no and would need to calculate a column Expected initial Entry no, that brings the initial entry no if an item has transferred ( it's differnt than zero). It is easy to bring the value if we have one transfer for example entry 2...
  3. L

    Count Distinct

    Hi-- I'm trying to count distinct text values in a range. I found this formula on another help site =SUM(IF(A2:A10<>"",1/COUNTIF(A2:A10, A2:A10), 0)) .... but it gives me a self-referencing error and returns 0 (My formula is placed in column B). Thanks in advance.

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