I am using this function =IF(ISBLANK($C8),($E8),($E8)) on individual cells
and it is working fine. My issue is when refreshing the data I won't know
how many cells will need the function. Can I use a similar function on an
entire column?
Thanks, Karen