Hi,
I have an sheet that contains 1000 records. In the sheet I would like to fill the empty cell using criteria.
For example: A4 contains value B and A10 contains Value C. So I would like to put H from A4 to A10, similarly A34 contains value B and A50 contains C so I would like to fill between cells with H.
The total records are more than 1000,
Any suggestion?
I have an sheet that contains 1000 records. In the sheet I would like to fill the empty cell using criteria.
For example: A4 contains value B and A10 contains Value C. So I would like to put H from A4 to A10, similarly A34 contains value B and A50 contains C so I would like to fill between cells with H.
The total records are more than 1000,
Any suggestion?