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 Column F Column G
DECKER | ||
C | CORNISH | |
SACHAR | ||
SHARIPOVA | ||
DHALIWAL | ||
JAHANT | ||
MCLAUGHLIN | ||
GOODMAN | ||
MCGILL | ||
YEARWOOD | ||
J | ORTIZ | |
AND | JOEL | FREEDMAN |
SMITH | ||
BAKARE | ||
LOZANO | ||
FELDTMAN | ||
ROSEAU | ||
WALSH | ||
MEYER | ||
GITA | ||
KORBAL | ||
UGWU | ||
EGAN | ||
VAN | HALSEMA |
<colgroup><col><col><col></colgroup><tbody>
</tbody>