Forum Discussion
Matching values
Please have a look on the Realized Qty column. I manually calculated realized qty column which is very time consuming because there're more than 1000 rows. When the realized value is blank, I have to...
=IFERROR(SUM(INDEX($A$2:A3,LARGE(IF($C$2:C3<>"",ROW($C$2:C3)),2)):INDEX($A$2:A3,MATCH(C3,$C$2:C3,0))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. Besides cell B2 all values are calculated by the formula. The formula is in cell B3 and filled down.