MrExcel Publishing
Your One Stop for Excel Tips & Solutions

presence/absence data from adjacent row

Posted by rick landenberger on August 29, 2001 10:59 AM

my problem is likely easily resolved, but i've tried several methods and haven't solved it myself.
here it is: i need to fill an adjacent row with either a "p" (or a 1) or an "a" (or 2, etc.), based on whether or not there is a value (a number) in an adjacent row.

thanks for any help,


Posted by IML on August 29, 2001 11:08 AM

How about:
and copying it down, assuming your data is in column A.

good luck