Forum Discussion

Alexander Bjerkvik's avatar
Alexander Bjerkvik
Copper Contributor
Jan 03, 2018
Solved

Formula that works on individual cells return absurd value when run on merged cells

I have developed this formula that enables me to match the highest number in a column with name of that product from another column, and add some text.    =INDEX(A81:A104;MATCH(MAX(M81:M104);M81:...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 04, 2018

    Hi Alexander,

     

    Merged cells is always an issue. I guess here is not with INDEX formula.

    Your merged J81.. cell looks like

    and if unmerge it it has a lot of side formulas inside

    (by the way, here is your current max %).  If remove all junk formulas and keep only one

    and now merge cells back (it will look as on first screenshot) you have correct result. At least here, perhaps in other places you have more side effects.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 04, 2018

Hi Alexander,

 

Merged cells is always an issue. I guess here is not with INDEX formula.

Your merged J81.. cell looks like

and if unmerge it it has a lot of side formulas inside

(by the way, here is your current max %).  If remove all junk formulas and keep only one

and now merge cells back (it will look as on first screenshot) you have correct result. At least here, perhaps in other places you have more side effects.

  • Alexander Bjerkvik's avatar
    Alexander Bjerkvik
    Copper Contributor
    Jan 04, 2018

    Thanks allot! :D I had no idea there were so many junk formulas in my merged cells. I cleaned up, and it is correct now. 

Resources