Forum Discussion

Ubaid ur Rahman's avatar
Ubaid ur Rahman
Brass Contributor
Apr 03, 2018
Solved

How to fill multiple cell one after another in one column refer to adjacent cell

In the table below you will see values so you can easily understand what I am asking for! This is what I have and which have no pattern in cells!     I want this as seen in the table...
excel
  • Tomasz Kocur's avatar
    Tomasz Kocur
    Apr 03, 2018

    Hi

    Use combined IF and LEN functions

    =IF(LEN(B2)=9,A1,B2) ect

     

Tomasz Kocur's avatar
Tomasz Kocur
Brass Contributor
Apr 03, 2018

Hi

Use combined IF and LEN functions

=IF(LEN(B2)=9,A1,B2) ect

 

  • Ubaid ur Rahman's avatar
    Ubaid ur Rahman
    Brass Contributor
    Apr 09, 2018

    Hi Tomasz,

     

    how to deal with the following in table.

    The formula worked until characters of supplier no was different that product no. but afterwards you find in the table given at the end product and supplier no are same in character.

    Can you please help!

    Thanks in advance!

    • Tomasz Kocur's avatar
      Tomasz Kocur
      Brass Contributor
      Apr 09, 2018

       

      Hi Ubaid

       Please see the file

      The best solution for that it could be to create a table with all suppliers number if you know them (or you can update every time if appears a new one)

       

      =IF(COUNTIF(Table1[SupMatNr],B3),B3,A2)

       

      I guess what you are trying to do, but first, I will have to see the source of the data, you can do that with the PivotChart Wizard, it is potentially the quicker way

      • Ubaid ur Rahman's avatar
        Ubaid ur Rahman
        Brass Contributor
        Apr 11, 2018
        Hallo Tomasz,

        I think its working now. Thanks alot!
        Can you please explain a bit what can we do with PivotChart Wizard?
  • Ubaid ur Rahman's avatar
    Ubaid ur Rahman
    Brass Contributor
    Apr 03, 2018
    Wow! thanks alottttt!!!!!

Resources