Forum Discussion

sheri_021's avatar
sheri_021
Copper Contributor
May 01, 2022
Solved

help in excel

here's image 1 with code matching different SKU. let's say this is file A  I need copy and past file A's code into file B. However file B is looking different  when I paste file A's cod...
excel
  • sheri_021's avatar
    sheri_021
    Copper Contributor
    May 02, 2022
    actually I change your equation like below for 2nd row

    More generally (allows column B data to be text or numeric):
    =IF(OR(A2="",A2=A1),"", INDEX(B$2:B2, SUMPRODUCT(--(C$1:C1<>""))))

    Change to :=IF(OR(A2="",A2=A1),"", INDEX(B$3:B2, SUMPRODUCT(--(C$1:C1<>""))))
    then rest of them fill correctly.

    I don't understand why, I was just give it try and play around. I don't know how to fix to make it correctly auto fill from row 1

  • sheri_021's avatar
    sheri_021
    Copper Contributor
    May 01, 2022
    OMG ~~~~ it does, the 2nd equation does the work.
    but there's little issue.. I replied and post it over there...
    YOU ARE AMAZING !!!! thank you so much
    • JoeUser2004's avatar
      JoeUser2004
      Bronze Contributor
      May 02, 2022

      sheri_021  wrote:  ``there's little issue.. I replied and post it over there``

       

      And that's the problem with crossposting:  trying to keep both threads up-to-date.

       

      I am continuing the discussion only at answers.microsoft.com.

Resources