Good morning,
This is one I have wrested with before.
is there a was (without using VBA) to turn a concatenation into a formula?
currently my (array) formula looks like this:
=CONCATENATE("(",ABS(G44),INDEX(Specifications[[Reading % Model 175]:[Counts Model 179]],MATCH(1,(E44&" "&D44=Specifications[Function])*(ABS(G44)>=Specifications[MIN Range])*(ABS(G44)<=Specifications[MAX Range]),0),MATCH("Reading % Model "&ModelMeter,Specifications[[#Headers],[Reading % Model 175]:[Counts Model 179]],0)))
basically it is concatenating: "(",600,*0.9%)+2 and as text is correctly returning: (600*0.9%)+2
however I would like to execute this formula, I have tried adding +0 at the end but it doesn't seem to work.
Can any one help?
Bookmarks