Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2012, 08:30 PM
mag mag is offline Excel Formula - Conditional replacement of cells Windows 7 64bit Excel Formula - Conditional replacement of cells Office 2010 64bit
Novice
Excel Formula - Conditional replacement of cells
 
Join Date: Oct 2012
Posts: 11
mag is on a distinguished road
Default 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!
Attached Files
File Type: xls Excel Formula Help 10-26-12.xls (344.5 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel Formula - Conditional replacement of cells Sum Formula in the range with Numeric and NonNumeric data cells Spanec Excel 2 01-12-2012 09:15 AM
Excel Formula - Conditional replacement of cells conditional formatting formula NEHicks503 Excel 1 11-30-2011 09:01 AM
Excel Formula - Conditional replacement of cells Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft