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...
  • Tomasz Kocur's avatar
    Apr 03, 2018

    Hi

    Use combined IF and LEN functions

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

     

Resources