Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Excel formula to return age at which difference in two values > 0

Posted on 2013-05-13
Medium Priority
273 Views
Hello Experts,

I need a formula to return a value in an adjacent column once the difference between two other numbers in two other columns is greater than zero. Please see the attached worksheet.

Thanks,
biker9
Age-where-balance-greater-than-0.xlsx
0
Question by:biker9
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 23

Accepted Solution

NBVC earned 2000 total points
ID: 39162408
tRY:

=INDEX(\$A20:\$A55,MATCH(TRUE,INDEX(C20:C55-\$B20:\$B55>0,0),0))

Copied across
0

Author Closing Comment

ID: 39162449
Perfect!

Thank you!

biker9
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month6 days, 21 hours left to enroll