• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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

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
biker9
Asked:
biker9
1 Solution
 
NBVCCommented:
tRY:

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

Copied across
0
 
biker9Author Commented:
Perfect!

Thank you!

biker9
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now