Choosecols and filter

Hi,
Recently I had used the formula
Choosecols(Filter(Ram!C5:R971,(Ram!E5:E971<>0)+(Ram!K5:K971)),1,2,3,9)

The output of second column contains numbers within braces for eg
ABC Pvt.Ltd,London (365489018)
but require - ABC Pvt.Ltd,London
so,how to modify in above formula such that it gives the result of 2nd column excluding braces that contains number also char(38)

How about (untested):

=LET(f,FILTER(Ram!C5:R971,(Ram!E5:E971<>0)+(Ram!K5:K971)),t,TEXTBEFORE(INDEX(f,,2)," ("),HSTACK(INDEX(f,,1),t,CHOOSECOLS(f,3,9))

If you want further assistance, provide a sample workbook.

Provide a sample workbook. Include examples of ALL types covering ALL eventualites.

Do NOT drip feed information.

I shall not help further until you have made an effort to provide a suitable sample set of data.

Waiting for a sample workbook ...

WHERE are your EXPECTED results?

And WHY am I having to prompt you for them? You have been a member here for long enough to undestand what is required. Please STOP wasting our time!!!

I shall have a look when, and only when, expected results have been added.

OK - I'll make ONE guess:

=LET(f,FILTER(Ram!C5:R971,(Ram!E5:E971<>0)+(Ram!K5:K971)),t,IFNA(TRIM(TEXTBEFORE(INDEX(f,,2),"(")),INDEX(f,,2)),HSTACK(INDEX(f,,1),t,CHOOSECOLS(f,3,9)))

So did you even bother to try post #8? Or are you REALLY expecting me to copy and paste it into the workbook for you? (Hint: I'm not offering to do so).

One last thing,how the formula would be revised if the extracted data last two column data are same.If you see in Expected Result sheet,col D & Col E value are same in 6th & 9th row.So I want to extract 6th & 9th row only.

Originally Posted by paradise2sr

No,its not required.I have now tested it has worked.
Thanx for the help.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

It's wrong. Try this:

=LET(f,FILTER(Ram!C5:R971,(Ram!E5:E971<>0)+(Ram!K5:K971)),t,IFERROR(TEXTBEFORE(INDEX(f,,2),"("),INDEX(f,,2)),u,HSTACK(INDEX(f,,1),t,ABS(INDEX(f,,3)),ABS(INDEX(f,,9))),IFERROR(FILTER(u,INDEX(u,,3)=INDEX(u,,4)),""))

I hope that you are not going to continue adding extra requirements. Please read post #4 again.