Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

increment cell reference by 1 every 6th row using -'excel,function,excel-formula,format,auto-increment'


increment cell reference by 1 every 6th row  using -'excel,function,excel-formula,format,auto-increment'

I need A1 to increment by 1 to A2 after 5 rows, and then to A3 after a further 5 rows etc.

What I need:

=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")


But this is happening:

=INDIRECT("'"&SheetList!$A1&"'!D3")
=INDIRECT("'"&SheetList!$A2&"'!D3")
=INDIRECT("'"&SheetList!$A3&"'!D3")


Even when I specify multiple A1's and drag it down, it still messes up.
    

asked Sep 7, 2015 by rajesh
0 votes
2 views



Related Hot Questions



Government Jobs Opening


...