How to get the unit price and quantity if only given the total spent

[Kiriko]

Hi, I'm trying to find out how many reams of A4 paper were purchased last year but I only have the total spent per month. The price may change monthly since there may have been purchased from varying suppliers.

Is there an easy way in excel to get that information? For example the below.

[TABLE="width: 234"]
<colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" span="2"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <tbody>[TR]
[TD="width: 84, bgcolor: transparent"]Month[/TD]
[TD="width: 84, bgcolor: transparent"]Unit Price[/TD]
[TD="width: 67, bgcolor: transparent"]Quantity[/TD]
[TD="width: 77, bgcolor: transparent"]Total Spent[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan[/TD]
[TD="bgcolor: transparent, align: right"]35.75[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"] 143.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"] 322.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mar[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"] 230.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apr[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"] 276.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]May[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"]??[/TD]
[TD="bgcolor: transparent"] 230.00 [/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott Huish]

There's not enough information there to manually get that information. Without the Unit Price, it's impossible to determine.
The closest you could possibly get is if paper was around the same price, you could get a close approximation, but that's it.