#1
|
|||
|
|||
Excel Formula - Conditional replacement of cells
In the attached spreadsheet I have columns "B" & "E" which is the raw data. I need to conditionally chose data from B & E to output it as in "F".
In fact I have a formula which works for the first 14 records in the excel spreadsheet shown, whose results I have in column G. I need to add to that formula (basically have a common formula, probably two IF statements, or a combination of "IF", "AND" & "OR" statements) that will work for all 18 records. My actual spreadsheet has 1000's of such records. So, I need to evolve a common formula that I can copy in column "G". Thanks in advance! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formula | UICOMP | Excel | 1 | 05-18-2012 12:59 PM |
Need formula for search and conditional formatting | MikeJedi | Excel | 9 | 01-13-2012 12:38 PM |
Sum Formula in the range with Numeric and NonNumeric data cells | Spanec | Excel | 2 | 01-12-2012 09:15 AM |
conditional formatting formula | NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |