Let's say that I have a named range TEST, that refers to an array.
The contents of the array is
{"bob","steve","larry";"larry","frank","steve";"steve","larry","bob"}
In cell A1 is "frank". What would be the formula I would need to determine the "row" position of "frank" (2)? How would I...