Forum Discussion
Solved
Formula Help - Stock control
Hi need help to build a formula to control our inventory but I´m running circles. - First time the item is added it needs to verify and return from the inventory sheet - 2nd and others should re...
I assume you don't work with Office365. If so you have to enter the formula as a matrixformula with ctrl+shift+enter. This puts the curly brackets (highlighted in yellow in the screenshot) around the formula in older versions of Excel e.g. in my Excel 2013.
I assume you don't work with Office365. If so you have to enter the formula as a matrixformula with ctrl+shift+enter. This puts the curly brackets (highlighted in yellow in the screenshot) around the formula in older versions of Excel e.g. in my Excel 2013.
OliverScheurichThanks, missed it! Worked like a charm!