drag values down diagnols

[ammartino44]

Hello. I have a value in A1, how can I create a formula that copies that value into B2,C3,D4,E5, etc. No code, just regular formula.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[hoyasaxa215]

Try:

Please Login or Register  to view this content.

[ammartino44]

I guess what I mean is a formula that won't require me to manually paste it in each diagnol. Maybe where I could just drag it down 100 rows and across 100 columns and it will hit all the diagnols. Does that make sense?

[popipipo]

=IF(ROW()=COLUMN(),$A$1,"")

Maybe this?

[DLC]

Hi,

=IF(ROW()=COLUMN(),CELL("row", A1),"")

is this something which you are looking....


Capture.PNG

[ammartino44]

POPIPO is a wise man.