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
3 views



Related Hot Questions



Government Jobs Opening


...