to get value from cell based on row number.

Hii..

I require formula in B1 such that when I drag it down I should get results as per the below table.

Row no. Value from cell
1 to 29 A1
30 to 58 A30
59 to 87 A59
88 to 116 A88

The Interval consists of 29 rows.

Thank you.

Many options here, one would be:

Formula:

Please Login or Register  to view this content.

if you need to scale further, dynamically, you could use something like

Formula:

Please Login or Register  to view this content.

Thanks a lot Xlent..