Hi everyone. I've run into a bit of a problem with one of my
worksheets. I have a column whose cells are either blank, "Buy" or
"Sell" I want the column next to it to put "***" in cells that are one

row up from a "Buy" and "xxx" in cells that are one up from a "Sell"
but I only want these to occur if below the "Buy" there is a "Sell"
ignoring the blank cells, and visa-versa for "xxx" when "Sell" is above

a "Buy" ignoring blank cells.


Thanks in advance for your help. I can elaborate if needed.


--
ph2da00
------------------------------------------------------------------------
ph2da00's Profile: http://www.excelforum.com/member.php...o&userid=28406
View this thread: http://www.excelforum.com/showthread...hreadid=479985