Book1.xlsxSorry, I honestly am clueless when it comes to excel.

Ok in the example below I have to divide the cost in col, J, by whatever amount of items are in col. F. So in row 2 I have one laptop so, that cost will stay as normal. In row 3 I have 3 items so I need to divide the cost (col. J) by 3. Ideally I would love a macro to insert rows under neath the rows that have more than 2 item and then do the maths in that row under the cost column but I dont think it is possible. The same idea would work for 2 items.

Again sorry for all the confusion and if this is not possible than I will just do it manually. ( Looking for an easy way out

Thanks