Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 11-12-2015, 01:32 PM
Mike91 Mike91 is offline Need formula for this Windows 7 64bit Need formula for this Office 2010 64bit
Novice
Need formula for this
 
Join Date: Nov 2015
Posts: 1
Mike91 is on a distinguished road
Default Need formula for this

Can someone help me please with this in Excel 2010:

In the example of the attached picture:



Example with yellow cells: numbers in A1 and B1 to be detected on the columns E, F, I, J (cells A1 and B1 are always side by side in this way), then these two numbers to be displayed in the cell M3 plus the maximal of the numbers from the cells: C1, G2 and K4 (neighboring cells). The final text (cell M3) must look exactly like in the picture.
Attached Images
File Type: jpg Example.jpg (49.8 KB, 20 views)
  #2  
Old 11-13-2015, 12:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need formula for this Windows 7 64bit Need formula for this Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Cross posted at excelguru.ca.
Please read http://www.excelguru.ca/content.php?184
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Need formula for this Better formula please Haha88 Excel 2 03-01-2015 03:36 PM
Need formula for this WHEN formula agent007 Excel 5 02-06-2014 09:20 PM
Formula Help clo312 Excel 11 01-11-2014 02:54 AM
Need formula for this formula help excelledsoftware Excel 8 03-25-2012 08:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:51 AM.


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