raghu
Got a doubt:
Excel spreadsheet, the rows are:
1-62
1-63
Blank cell
1-75
1-76
Blank cell
My requirement is: wherever there is a Blank cell, it should be populated with the previous cell number +1
and placed within brackets.
For example the first Blank cell should become (1-64)
The next Blank cell should become (1-77)
Like this, there are hundreds of rows.
This should happen automatically through a script/formula/macro.
Need urgent help.
Got a doubt:
Excel spreadsheet, the rows are:
1-62
1-63
Blank cell
1-75
1-76
Blank cell
My requirement is: wherever there is a Blank cell, it should be populated with the previous cell number +1
and placed within brackets.
For example the first Blank cell should become (1-64)
The next Blank cell should become (1-77)
Like this, there are hundreds of rows.
This should happen automatically through a script/formula/macro.
Need urgent help.