Can I do this frame in any place and any cell by formula
Printable View
Can I do this frame in any place and any cell by formula
Put this formula in A1 and copy it across to O1, then copy A1:O1 down as far as you will want the rows to ever be filled to...
=IF(OR(ROW()>$Q$1,COLUMN()>$P$1),"",IF(OR(ROW()=1, ROW()=$Q$1),REPT($R$1,2),IF(OR(COLUMN()=1,COLUMN() =$P$1),REPT($R$1,2),"")))
Great ..Great
You are a genius
You have overstated my abilities by quite a lot, but I do appreciate the sentiment, so I will simply say "thank you".
"thank you"