Column Comparison

[Guest]

Hello

I have five columns on my spreadsheet with ratings for 2003 (columns A,B,C,D,E) and then 5 columns with ratings for 2004 (columns F,G,H,I J). What I would like to do is figure out a formula that would say ... If there are no ratings in columns F,G,H,I,J, pull values from columns A,B,C,D,E. May final outcome would be to make sure there are ratings in columns for 2004 for each line item

Let me know if you have questions

Thanks
Berlinda

 

[Frank Kabel]

Hi Berlinda
if I understood you correctly this won't work. Problem is you can
either have a formula in a cell OR a manual entered value. Your kind of
solution can only be done with a macro which is run after you have
entered all values.

But maybe I'm just missing something in your description

--
Regards
Frank Kabel
Frankfurt, Germany

Hello!

I have five columns on my spreadsheet with ratings for 2003 (columns

A,B,C,D,E) and then 5 columns with ratings for 2004 (columns F,G,H,I
J). What I would like to do is figure out a formula that would say ...
If there are no ratings in columns F,G,H,I,J, pull values from columns
A,B,C,D,E. May final outcome would be to make sure there are ratings
in columns for 2004 for each line item.