Most valuable professional
  • Hot Topics

Excel Find first number in column using match/index function

Hello, Can someone pls. assist me with providing a formula, ideally using the index/match functions, to locate the first absolute (may have positive or negative values) number in a column? I have added snapshots of how the data would look on the two sheets they are currently located on. Thank you in advance. Sheet 1 ID 12345678A 12345678A 12345678A 12345678B Sheet2 ID 12345678A

This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of June 3, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel