Forum Discussion
Formula Help - Create formula based on last column entry
Hi all, Apologies if this query has come up previously.. I am trying to create a simple formula in column B that uses the latest column of filled data (i.e. column E in the screenshot below) an...
nph20 Made easier if you could break-out the Allocation% calculation from rows with stock quantities, as demonstrated in the attached workbook. Though, I would not call the formula "simple".
nph20 , A variation using INDEX and MATCH using Riny_van_Eekelen workbook.