Forum Discussion
AdrianMgdal
May 30, 2023Copper Contributor
Problem with formula
Hello i need help with my Excel. like i show elowe in printscreen i need to make delta of Stock and demanding quantity but how to make it for indexes that are dubbled to take stock - first demand and...
OliverScheurich
May 30, 2023Gold Contributor
=IF(COUNTIF($A$2:A2,A2)=1,B2-C2,INDEX($E$1:E1,LARGE(IF($A$1:A1=A2,ROW($A$1:A1)),1))-C2)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The index numbers don't have to be entered in consecutive rows. For example index 13111129 is in cells A11, A12, A13 and A15 or row 11, 12, 13 and 15.