Forum Discussion
My formula stop working in the middle row position
Hello there, In simple description, I just make an cigarettes inventory checklist for my company. I have 1 excel file containing 2 sheets inside. The first sheet is called "Data Barang", and t...
I don't know what the ISNUMBER() part is for.
Using structured references:
=[@[Stock Awal]] - SUMIF(Table3[Kode], [@Kode];Table3[Jumlah])I deleted all blank rows.
There is a formula in sheet "Log Pemakaian" which refers back to sheet "Data Barang". And the formula in sheet "Data Barang" refers back to sheet "Log Pemakaian". That is not a good practise.
Changing the formula in sheet "Log Pemakaian" to structured references:
=INDEX(Table4[Kode],MATCH([@[Nama Rokok]],Table4[Nama Rokok],0))