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
This question generated 28 answers. To proceed to the answers, click here.
This thread is current as of June 03, 2014.