What is the simplest way to get an array formula to return the integer that represents its index? IE, I have an array {John,apple,4,TRUE,7} and I want {1,2,3,4,5} to be the result. Previously, I had been using MATCH(RANGE,RANGE) to obtain this but it backfired when some of the elements in the...