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

     

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

Resources