![]() Of all the sorting I did, I have to say that sorting by the most expensive purchases actually ended up being my favorite method of analyzing the data. Once you've taken a guess, simply sort column AD "Item Total" (for post-tax price) or column M "Purchase Price Per Unit" (for pre-tax price) with the Z-A sort function to display the highest value at the top of the page.Ī GPU and a high-end monitor were, in fact, among my top 10 most expensive purchases, but it turns out the top two things were an ultra-lightweight wheelchair for my father-in-law and a premium saddle-style window air conditioner. ![]() I, for example, guessed that surely the most expensive thing I've ever bought off Amazon was a GPU, a high-end monitor, or some other equally expensive bit of tech kit. Before you do so, though, it's kind of a fun game to try and guess what you think the item is. To find the most expensive thing you've purchased on Amazon, you can choose to sort by the pre-tax or post-tax price. What Is the Most Expensive Thing I've Bought Off Amazon? Then just skip over your own name and look at everything you've shipped to everyone else. You can sort column T, "Shipping Address Name," to sort all your Amazon shipments by the name of their recipient. You may have to pore over the data and look for purchases made around holidays you celebrate such as family members' birthdays, Christmas, or other gift-giving holidays, to really dial it in.īut if you use Amazon a lot to ship gifts to friends and family around the country, you're in luck. This particular question is a bit tricky to answer because not every gift you purchased on Amazon was necessarily shipped by Amazon to the recipient. If your total purchase history comes to $20,000 and the total refund history comes to $1,600, then the total amount you've actually spent on Amazon is $18,400. Now just subtract the value of the purchase and tax refund from the total value we just created on the "Items" spreadsheet. With the number of the final row, such as J40 Scroll to the bottom and combine column J "Refund Amount" with column K "Refund Tax Amount" using the function =SUM(J2:JX, K2:KX) Because the refund report provides the purchase price refund and tax refund in separate columns, we need to combine them. Now, repeat the process by creating a SUM function on the "Refunds" report. The resulting value is the sum of the column and represents the total amount of money you have paid Amazon. Is the value of the last data row, such as AD1209 Scroll to the bottom of the column and create a simple sum function in your spreadsheet application like =SUM(AD2:ADX) Other columns in the spreadsheet, such as column M "Purchase Price Per Unit," show the pre-tax price, and column L, "List Price Per Unit," shows the list price, not the actual price. To get an accurate look at how much you have spent on Amazon over the years, we need to use the SUM function to add up two values: how much you've paid out to Amazon and how much they've refunded you.įirst, in the "Items" spreadsheet, you need to locate column AD, "Item Total." This column indicates what you actually paid with the tax included. If you want to know how many orders you have placed, sans returns and refunds for damaged shipments and such, you can also subtract the same value (number of lines minus one) found in the "Refunds" spreadsheet from your total orders. If your spreadsheet is 1,295 lines, for example, you have played 1,294 orders on Amazon. The number of Amazon orders you have placed on Amazon is the total number of lines in the "Items" spreadsheet minus one (because one row of the spreadsheet is the headers at the top). Related: How to See the First Amazon Purchase You Ever Made In my case, it's the textbook I mentioned at the start of the article. The top entry should be the earliest purchase. Or, in the Items spreadsheet, you can sort column A, "Order Date" using the A-Z sort function. You can look in the regular Orders page on your Amazon account to see the first thing you ever purchased on Amazon. What Was the First Thing I Purchased on Amazon? In the following instructions, we'll be referencing the column letter and title with confidence it will look the same for you, but please adjust the instructions to reflect any changes to the column arrangement. The formatting of these Amazon purchase history spreadsheets has stayed very consistent over time, with reports we've pulled at points over the years using the same formatting conventions. ![]() With the "Items" spreadsheet and the "Refunds" spreadsheet loaded, here are some interesting questions you can answer about your Amazon purchase history and how to answer them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |