OP does not want to manually insert formulas so I believe this requires VBA:
https://www.excelforum.com/excel-gen...ple-sheet.html
Edit: It doesn't sound like they want a VBA solution either. Not sure any solution will be approved by them but I'll leave this here anyway.
Bookmarks