Finding matching numbers in 2 excel columns
Closed
Mark
-
11 Jun 2010 à 12:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Jun 2010 à 20:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Jun 2010 à 20:49
Related:
- Finding matching numbers in 2 excel columns
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Five nights in anime 2 - Download - Adult games
- Excel mod apk for pc - Download - Spreadsheets
- Feeding frenzy 2 - Download - Arcade
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Jun 2010 à 16:59
11 Jun 2010 à 16:59
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
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Jun 2010 à 20:49
11 Jun 2010 à 20:49
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 {}
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 {}
11 Jun 2010 à 20:22
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