Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2010, 04:50 PM
Corca Corca is offline Help with Formula Windows Vista Help with Formula Office 2007
Novice
Help with Formula
 
Join Date: Feb 2010
Posts: 9
Corca is on a distinguished road
Default Help with Formula

Hi,



Need help for a formula to do as show in attached file.

Can someone help please, it's appreciated.

Corca.Corca Help File.pdf
Reply With Quote
  #2  
Old 02-19-2010, 04:56 PM
Corca Corca is offline Help with Formula Windows Vista Help with Formula Office 2007
Novice
Help with Formula
 
Join Date: Feb 2010
Posts: 9
Corca is on a distinguished road
Default

USE THIS ATTACHMENT AS OTHER DID NOT HAVE COLUMN AND ROW REFERENCES

Corca Help File.pdf

cORCA.
Reply With Quote
  #3  
Old 02-21-2010, 03:49 AM
BjornS BjornS is offline Help with Formula Windows Vista Help with Formula Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hello Corca,
I have attached a proposal for solution.

In the solution I assume that you always enter (cell b9, b10) the highest value per row. If you can also select second the highest value, the solution needs to be built up differently (if that is the case, please inform me more about the logic of your data, and I will try to fix a new solution for you).

Kind regards
Bjorn
Attached Files
File Type: xls High_Breaks.xls (15.5 KB, 21 views)
Reply With Quote
  #4  
Old 02-21-2010, 09:43 PM
Corca Corca is offline Help with Formula Windows Vista Help with Formula Office 2007
Novice
Help with Formula
 
Join Date: Feb 2010
Posts: 9
Corca is on a distinguished road
Default

Thanks,

Looking for it to look in range e1:h5 pick match for b9 then find name from name column b2:b5. Then put found name into A9.

Need forumla to do the above without changing sheets layouts.

Thanks for your input appreciated.
Reply With Quote
  #5  
Old 02-22-2010, 09:16 AM
BjornS BjornS is offline Help with Formula Windows Vista Help with Formula Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
some short questions.

Assume that also Tom Jones has a value of 30 in cell F3. How shall the formulas react if you enter 30 in cell B9? (since both Tom Jones and Ian Gilbee are vald answers in cell A9). Could the answer be any of those two?

Is it possible that you enter "33" in cell B9, and like to get the answer "Peter Jones" in cell A9 (although he has another value, like 70, which is higher)?

What result would you like to have in cell A9 if a zero is entered in cell B9?

Should the formulas in A10+B10 works in exaclty the same way as the formulas in A9+B9?

Regarding "not changing the layout", is it allowed to add any formulas on a separate worksheet OR below the data (line 15 and below)?

Best regards
Bjorn
Reply With Quote
  #6  
Old 02-22-2010, 12:56 PM
BjornS BjornS is offline Help with Formula Windows Vista Help with Formula Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi again,
meanwhile I fixed a solution that I think meets the demands that you have specified.

If several persons matches to the input data, the name closet to the top is chosen.

Best Regards
Bjorn
Attached Files
File Type: xls High_Breaks 2.xls (15.5 KB, 13 views)
Reply With Quote
  #7  
Old 02-22-2010, 09:40 PM
Corca Corca is offline Help with Formula Windows Vista Help with Formula Office 2007
Novice
Help with Formula
 
Join Date: Feb 2010
Posts: 9
Corca is on a distinguished road
Default

Thankyou, this works great.

The spread sheet used is not mine and has a lot of data otherwise it should have been rebuild, maybe later but is a lot of work.

This works great for this problem.

thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Help with Formula Timesheet formula help beardking Excel 2 11-10-2009 02:06 AM
Help with Formula If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Help with Formula Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.


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