Excel: How to Compare Column Values in a Row
- by spazzie
I have a bunch of comparison data and a lot of entries being compared. As an example, say my sheet looks like this, give or take a few columns:
Item Price1 Quantity1 Price2 Quantity2 Price3 Quantity3
001 $123 12 $456 24 $789 48
002 $100 95 $200 5 $300 51
…