B
belvy123
I have a sheet that I use for production numbers at work
There are 3 columns of 37 rows
I want to be able to find the second non blank cell in each column and then
get an average from the sum of the second cell to 37th cell in that column
and be able to do this for each column.
However I am not able to figue out how to do this as the second non blank
cell in each column may be different. ( Column one the second cell may be in
row 4 and in Column 2 the second cell may be in row 2 and in Column 3 the
secind cell may be in row 6) The reason that I want the second cell is that
the first cell of production numbers are never used to calculate average
production.
Please help
Thanks
Dan N
There are 3 columns of 37 rows
I want to be able to find the second non blank cell in each column and then
get an average from the sum of the second cell to 37th cell in that column
and be able to do this for each column.
However I am not able to figue out how to do this as the second non blank
cell in each column may be different. ( Column one the second cell may be in
row 4 and in Column 2 the second cell may be in row 2 and in Column 3 the
secind cell may be in row 6) The reason that I want the second cell is that
the first cell of production numbers are never used to calculate average
production.
Please help
Thanks
Dan N