Excel/Google Sheets Formula/Lookup Method To Find Largest Discrepancy
Excel/Google Sheets Formula/Lookup Method To Find Largest Discrepancy
Your information is formatted incorrectly.
Products are listed in rows, prices in columns.
Column A contains the product name,
Column B shows the Amazon price,
Column C displays the eBay price,
Column D is the difference between the two prices.
Sort the data by Column D in ascending order.
that's precisely what I was considering too. just take away the two prices and arrange that column by size. keep in mind though, you shouldn't worry about the +/- outcomes because you're only interested in the difference, not which site has which price. apply the absolute value in the calculation so it doesn't distract you with positive or negative signs. this will speed up the sorting process, placing all significant differences at the top of the list.