Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
conditional search
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Conditional Formula to search ranges?? | Excel Discussion (Misc queries) |