Hello,

I would need help solving this in excel. If you could do a step by step solution and using numbers instead of cell references to avoid any confusing and so I can learn and rehearse the calculation.

Thanks in advance.

Question 4:
In a Dutch auction, the number of shares being auctioned is 210,000. The bidders are as follows:
	Bidder	Number of Shares	Price ($s)
	A	40 000,000	57,00
	B	50 000,000	87,00
	C	50 000,000	62,00
	D	40 000,000	45,00
	E	40 000,000	49,00
	F	60 000,000	49,00
	G	20 000,000	42,00
	H	30 000,000	67,00
a. What's the price paid by the investors?
b, How many shares does each investor receive?