Hello,
I have 2 pricelists, each pricelist have 2 columns(DESPRIPTION and PRICE). I would like to compare them and find the increase or decrease in price and new added products. The product description never changes but the price does frequentely, so i need to find a way to spot the diferences easy, my pricelist goes up 2000 rows so you can imagine that is very time cosuming job to do by hand every 2 weeks.
The best solution i found is with conditional formating, but i cant make the formulas work for me.
In the past 2 days i red everything i could find, I' ve searched every possible combinations in google but none of the solutions i found worked for me, so here I am.
Thank you all in advance
I have 2 pricelists, each pricelist have 2 columns(DESPRIPTION and PRICE). I would like to compare them and find the increase or decrease in price and new added products. The product description never changes but the price does frequentely, so i need to find a way to spot the diferences easy, my pricelist goes up 2000 rows so you can imagine that is very time cosuming job to do by hand every 2 weeks.
The best solution i found is with conditional formating, but i cant make the formulas work for me.
In the past 2 days i red everything i could find, I' ve searched every possible combinations in google but none of the solutions i found worked for me, so here I am.
Thank you all in advance