Probably a really easy one... definitely easy with a macro (CTRL+SHIFT+LEFT)
I have a range of formulae in a column, currently like this:
=MIN(A1:A3)
=MAX(B1:B3)
=AVERAGE(C1:C3)
=SUM(D1:D3)
=SUM(E1:E3)/15*100
I would like to be able to copy all these formulae to another part of the sheet to essentially apply the formulae to 'everything left of the posted cells'
i.e. if I posted them in K10
=MIN(everything from K1-K9)
=MAX(everything from L1-L9)
=AVERAGE(everything from M1-M9)
=SUM(everything from N1-N9)
=SUM(everything from O1-O9)/(number of cells highlighted with values*5)*100
I could cut and paste most of these formulae and/or write a macro, but I'd like to copy this to any workbook and not all are macro-enabled... I'm stuck with the last one in particular
When I paste that formula to any workbook, I want the formula to say 'select all cells left of this cell, count how many cells have numerical values and multiply it by 5 in this case...
=SUM(everything to the left of the pasted cell)/(COUNTA(number of cells to the left of the pasted cell with values)*5)*100 ???
btw, I've posted a number of times on this forum and everyone is absolutely amazing... I've appreciated every second you've all put in to helping in the past!
Bookmarks