What formula used to scale the same code a value on different days

[Berna11]

hello, as I said in the title I need your help to scale a value for the same code on different days.
From the attached file you can see what I mean.
Thanks for your help

Scalare valore.xlsx

[Richard Buttrey]

Hi,

One way in E2 copied down

Please Login or Register  to view this content.

[Berna11]

Hello Richard
PERFECT! thank you very much it works
hello

[Berna11]

Excuse the comparison it must do between column A & B (see my formula in E2) I do not work putting the two columns

[Richard Buttrey]

Hi,

Are you saying there may be other colours for the same Code number?

Your example showed a one to one match. i.e. could there be a red code 112233 as well as a yellow?

[Berna11]

Hello Richard
It, is exact as you say there may be different colors for the same code.
I apologize that I had not pointed out in the example, but I thought that the words I had used you could guess.
Thanks again and sorry for the inconvenience.

[Berna11]

Hello Richard
It, is exact as you say there may be different colors for the same code.
I apologize that I had not pointed out in the example, but I thought that the words I had used you could guess.
Thanks again and sorry for the inconvenience.

[Berna11]

Sorry I have modified the formula:

Please Login or Register  to view this content.

ut does not control the code + color
column A + B
Can you help me thanks

[Richard Buttrey]

Hi,

It's probably advisable (and simpler) to use helper columns, see attached.

[Berna11]

Hello Richard now is ok thank you very much.
the next
Hello Berna