compare two price rating

[SalmanZeiad]

How to compare two price by date and item..
For example Compare price lcd and give me color bar to tell me rate up or down>>>Not For all items and all prices

 

[jdraw]

Perhaps you could give us an example of what you expect by using a sample of your own data.
My first reaction is to recommend:
Allen Browne's Subquery info
Conditional formatting

 

[SalmanZeiad]

Perhaps you could give us an example of what you expect by using a sample of your own data.
My first reaction is to recommend:
Allen Browne's Subquery info
Conditional formatting

 

[Minty]

This is not trivial, and has a number of prerequisites - The things you are trying to compare must have a unique matching key - a model number/product code or similar.
Also what if an item is new or has dropped off your listings? I assume you want those also highlighted?

As it stands if you have 3 different products all called LCD it won't work.

As JDraw said we could do to see a larger set of your data and what outcome you expect.

 

[SalmanZeiad]

uploaded file

 

[SalmanZeiad]

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com