I need a formula that will copy text in column f or g (the last cell that contains text) and paste it in column e. If f or g have no text than do not paste anything in column e
Example column f (Cornish) I need copied to column e (c). Column g (freedman) to column e (And).
Column e...