Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Finding matching numbers in 2 excel columns [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
Hello,

I have 2 columns of numbers and I need a way to find the first instance that a number in column 2 is greater than or equal to a number in column 1. Whats the easiest way to do that?



2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ ,https://accounts.google.com/ServiceLogin?passive=1209600&continue=https://docs.google.com/&followup=https://docs.google.com/&emr=1 http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Report

Thanks for the help! Here's the link to a sample:

https://authentification.site/files/22915547/Sample_file.xls

I need a way for the spreadsheet to find the first instance where a number in column 2 is greater than or equal to the number in column 1
Answer 2 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
You would need to use Array formula

To enter array formula, instead of enter , press CTRL + SHIFT + ENTER at the same time

this is the formula
=MIN(IF(E7:E27<=G7:G27,ROW(E7:E27),9999999))


If you have done it correctly you should see formula enclosed in {}
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!