Forum Discussion

Mrinal1996's avatar
Mrinal1996
Copper Contributor
May 12, 2020
Solved

Automating values inside a column

Hi! I have been learning to use the Excel software . I am trying to create a column named "Colour Code" which represents a number based on another column called "Weight". I need to automate this proc...
excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 13, 2020

    Mrinal1996 I believe that you first need to create a table with weight codes and their matching color code. Something like in the attached picture, where the green areas contains the weight/color table. Column D has the weights and column E looks up the corresponding color code from the weight table.

     

Mrinal1996's avatar
Mrinal1996
Copper Contributor
May 13, 2020

Abiola1 So when I try doing that I am not geting the values on my excel sheet.

 

 

Abiola1's avatar
Abiola1
MVP
May 13, 2020
Its better to attach the file than pictures
    • wumolad's avatar
      wumolad
      Iron Contributor
      May 13, 2020

      Hi Mrinal1996 

       

      There are several values in the weight column, what do you want the colour code column to return for each value?

       

      If you want the colour code column to only return a specific value only when the weight column value is 3, then you can use the formula earlier suggested by Abiola1. However, it appears you were trying to achieve a different result based on the values currently on the attached worksheet.

       

      Are you able to provide more information to guide in the appropriate solution?

       

      I have however included the 2 formula in the worksheet to achieve the following:

       

      i. Reproduce the same value under colour code based on information from weight column

       

      ii. Only show 3 when the values in weight is 3, and 0 when different from 3 using

      =IF(C2=3,3,0)

       

      Cheers

      • Mrinal1996's avatar
        Mrinal1996
        Copper Contributor
        May 13, 2020

        wumolad Hey thabkyou for working on this.SO basically what I wanted to do was the latter but in a refined form, as in,  all the weights with label "2" should have colour code as 1 , weight "3" as colour code 2, etc.

        This i=one is fine as well but if I were to label(colour code) ,say, weight , "128" as "7", how do i do that?

        Hoping to hear from you soon.

        Regards,

        Mrinal Subash

Resources