Can anyone help. I have three columns. Column A is age, column b is stream of values increasing with age, column b is stream of values increasing with age. I need to find the age at the value in the c column exceeds that in the b column. For example I'd like a formula along the last row that, in this case, returns the age 57.
Age value1 value2
56 100 99
57 102 103
58 103 107
I've attached the file.
Thanks for any help!!
Hi
maybe:
to be confirmed with control+shift+enter.
Please Login or Register to view this content.
Regards
Last edited by canapone; 01-29-2012 at 10:07 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi,
if you would need to cut out all the decimals after the second one (1.2555555=1.25 5.45907333=5,45), same formula:
control+shift+enter to get 184, the yellow number.Please Login or Register to view this content.
Hope it helps
This works beautifully. I can't thank you enough for helping me on a Sunday.
Best regards,
Charlie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks