Quote:
Originally Posted by whatsup
Hi Will
How much do you know about excel? You will need at least to know excel's feature for evaluating formulas, and how to create array formulas:
|
The whole formula as you posted, is quite sophisticated. It won't work with numeric values, unless you change REPT("z",255) to - for example - 9^9
******
Try this A1:A10
a1a11a1df12b1qwe12bccasdasd102aasd1ws
with this E1:E10
wedfqwfghhtr2a1a1asdrrr2ddd
You get
a1a1a1ANOTHER VALUEqwANOTHER VALUEasdasdANOTHER VALUEasd
That is only 2 results correct!
Is it a sophisticated formula?
Bad formula and bad analysis!
Bruno