Compare 2 rows and column and calculatre

COmpare the column 'model' and value and if the model number is same then only one value should eb showsn for eg for model 301 value should be 2000 and model 101 value is 8000 instead of calculating all the values.

Product        Model       Value

Phone          301            2000

Phone          301            2000

Phone          301            2000

Phone          101             8000

Phone          101             8000

Phone          101             8000

(1) Answer

Login