Filling form with excel formulas

Occasional Contributor

Hello everyone.


I have attached a sheet. Please help to open that and fill the table with excel formula/function from G10 to I17 from the picking data from A9 to B30. 

2 Replies



You can try this formula. Enter the formula with ctrl+shift+enter as an arrayformula.



Thanks a lot dear for your help and giving your valuable time.