Forum Discussion
Filter function help
Hi, I am in the process of updating and managing our work projects log. As you will see from attached document I have merged rows at the beginning of the table to allow each project to include a...
I am trying to insert this formula into the spreadsheet as you have mendtioned. Could you give me a written out complete formula for the first group of boxes please as i cant seem to get it to work. Do i change every n for one row number or for each consecutive row number?
so In cell I4 the formula would be IF(An="",I(n-1),An)
In cell I5 the formula would be IF(An="",I(n-1),An)
In cell I6 the formula would be IF(An="",I(n-1),An)
In cell I7 the formula would be IF(An="",I(n-1),An)
for the cell i4 the formula is =if(a4="",i3,a4)
copy the formula and paste it in the i4 cell
then simply drag the formula down across all the rows
copy the formula and paste it in the i4 cell
then simply drag the formula down across all the rows