CODEWITHSUNDEEP
excel
Daniel Otto
Daniel Otto

Reputation: 75

Formula that retrieves the cell value of another cell the row below it

I've got a dataset which has a blank row and a file name in the row below it repeating for the whole sheet multiple times. Each file name is different and what im wanting to capture in the currently blank row is the cell value of the cell below it i.e the filename with a formula.

Im not very proficient in excel sheets but feel this is something simple? This provides me what i need but it is not dynamic. ="FILENAME IS" & A2

I need a formula i can copy across all the blank rows which will do something like ="FILENAME IS" & A:ROW()+1

Thanks in advance :)

Upvotes: 1

Views: 326

Answers (1)

Daniel Otto
Daniel Otto

Reputation: 75

Obviously my lack of knowledge but thanks kto Foxfire And Burns And Burns ;

Simply copying ="FILENAME IS" & A2 into the blank rows did the job as A2 became A4 and A6 and so on when copied.

Upvotes: 2

Related Questions