I have a column of cells, from U7 to U21, that contain various numbers.
Some numbers may be duplicated in this range.
To return the first row number that matches a given value (in the example below the target value is '12' )
Question / Issue
I want to return the row number of the first match. I do NOT want to use an array formula
I have tried the following formula but this will always return zero since it is the lowest number in the true / false array generated or matching cells:
How can I modify this to return the first non-zero number ??
I have tried various other formulas but they either fail or need to be entered as CSA formulas and I do NOT want that.
Any help would be much appreciated as since I know I have done just this in the past but can't remember how I am going mad ! I will no doubt kick myself when someone reminds me.
I also don't want to use VBA or a user-defined-worksheet-function.