formula auditing/evaluate formula
I fully understand; thank you very much!
FLKulchar
"T. Valko" wrote in message
...
When I perform 'formula auditing'/evaluate formula...I get:
for....SEARCH({0,1,2,3,4,5,6,7,8,9},A7&"01234567 89")
the following:
({4,6,7,8,2,10,11,12,13})
Why do I NOT SIMPLY GET: 4
Because your processing an array of values: SEARCH({0,1,2,3,4,5,6,7,8,9}
So, you get an array of values in return: {4,5,6,7,8,2,10,11,12,13}
--
Biff
Microsoft Excel MVP
"F. Lawrence Kulchar" wrote
in message ...
I have:
In Cell A7: A55
In Cell B7:
=LOOKUP(9.9E+307,--MID(A7,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A7&"012345 6789")),ROW(INDIRECT("1:"&LEN(A7)))))
When I perform 'formula auditing'/evaluate formula...I get:
for....SEARCH({0,1,2,3,4,5,6,7,8,9},A7&"0123456789 ")
the following:
({4,6,7,8,2,10,11,12,13})
Why do I NOT SIMPLY GET: 4
Thanks,
FLKulchar
|