Formula Extension

Copper Contributor

Hi,

 

I am wanting some help with a complex formula. I need to extend the formula to cover from 60 columns to 500 and the only way I can think of doing it is typing in the formula cell by cell. Is there another way that's less time consuming?

excel.PNG

 

Appreciate any support!

 

Thanks, Taylah.

2 Replies

@Taylah 

We cannot see the complete formula and we cannot see in which cell it is.

Could you attach a sample workbook?

if you can copy formulas down many rows by pulling the fill handle, i am sure that you can do the same for columns

Here's proof:

Yea_So_0-1620875897980.png