Forum Discussion

Mgaltieri's avatar
Mgaltieri
Copper Contributor
Jul 11, 2023
Solved

Excel function

  I need to write an excel function that: If column B color is #FFC7CE, then take column C value and copy it to D as many times Column B value is repetead on column A.   This is how it should l...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 11, 2023

    Mgaltieri 

    Okay, thank you. Perhaps you mean

    with formula in E1 as

    =IFERROR( INDEX( C:C, MATCH( $A1, B:B, 0 ) ), $C1 )

    and drag it down.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 11, 2023

Mgaltieri 

In Excel functions don't work with cell properties like color, only with values. That's only with VBA if you consider such option.

Mgaltieri's avatar
Mgaltieri
Copper Contributor
Jul 11, 2023
Ok, thanks. Do you know if I can use another formula to check only for the repetead values?

Resources