myhousekey Posted June 14, 2007 Share Posted June 14, 2007 (edited) I need a formula that will look at a particular column and return the value in that column. However, if no value exists it will look in the cell immediately above it and return that value. If no value exists in that cell it will look above it and so on…. Ie something that does this: B10 = A10 If A10 = blank then B10 = A9 If A9 = blank then B10 = A8 etc… When I say "blank" above I am referring to an empty cell. Ideas? Edited June 14, 2007 by myhousekey Quote Link to comment Share on other sites More sharing options...
myhousekey Posted June 14, 2007 Author Share Posted June 14, 2007 Nevermind....got the answer.. =if(trim(a10)="", b9, a10) Quote Link to comment Share on other sites More sharing options...
Kid Cid Posted June 14, 2007 Share Posted June 14, 2007 (edited) By not answering, I've enabled you to help yourself. You're welcome. Edited June 14, 2007 by Kid Cid Quote Link to comment Share on other sites More sharing options...
MikesVikes Posted June 14, 2007 Share Posted June 14, 2007 Does this question have anything to do the the Vikings receiver projections? Quote Link to comment Share on other sites More sharing options...
Ursa Majoris Posted June 14, 2007 Share Posted June 14, 2007 Does this question have anything to do the the Vikings receiver projections? Yes. It has a bunch of blanks in the answer. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.