View Single Post
 
Old 11-05-2019, 05:28 PM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

A formula cannot replace what is already in a cell. The only way this can be accomplished is with VBA.

How about using an additional row?
Attached Files
File Type: xlsx recalculate (1).xlsx (9.1 KB, 8 views)
Reply With Quote