Filter and Convert Data

[ionelz]

Hi,
See data in column A,B,C
1 Name1 True
2 Name2 True
3 Name3 False

I want to Filter with one operation A and C and convert A (numbers stored as text) to numbers and C (True ,False stored as text) to Boolean
Result is
1 TRUE
2 TRUE
3 FALSE
Thank you

 

[DanteAmor]

Try:

=LET(a,CHOOSECOLS(A2:C4,1,3),IFERROR(a+0,IF(a="True",TRUE)))

 

[ionelz]

Ok, but I get TRUE and FALSE in first column too
In first column I should get NUMBERS converted from text to number

 

[DanteAmor]

but I get TRUE and FALSE in first column too

Could you give a more complete example?
According to your first example the formula works.

In first column I should get NUMBERS converted from text to number

And that makes the formula:

 

[ionelz]

maybe because I am getting A B C with formula ?

 

[DanteAmor]

I did the test with formulas and in columns E and F I get the correct results.

Maybe I should fix your formulas that you have in A,B,C so that they return numbers and booleans.

 

[ionelz]

Try:

=LET(a,CHOOSECOLS(A2:C4,1,3),IFERROR(a+0,IF(a="True",TRUE)))

I will look and let you know

 

[ionelz]

Understood,.
How above formula looks if I want to Filter ABC, B as is ! (A and C have the conditions already)