|
|
#1
10-27-2012, 08:30 PM
|
|||
|
|||
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 |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
