How to add New Rows in Conditional Match jmp 15

Elby — Fri, 09 Jun 2023 00:46:38 GMT

Hello,

Is it possible to automatically add new matches to the formula?

My data contains a Conditional Match Formula to group data.

I.E. the data includes Rows like PartA-V1, PartA-V2, PartA-V3 and PartB-V1, PartB-V2, PartB-V3 that the matches would be PartA or PartB since the -V does not change what I am looking for. The actual data is has more complicated descriptions. The original data had ≈50 Matches so recreating the entire match table/formula is not easy.

The issue is - when new data, PartA-V4, PartC-V1, they are not included in the prior match functions.

Thank you for any assistance.

Re: How to add New Rows in Conditional Match jmp 15

Georg — Sat, 12 Mar 2022 17:46:43 GMT

If I understand correctly, you need a more general formula to group your data.

I would use e.g. "words" if the string has always a "-" and you need the first part, like follows:

Words("PartA-V1", "-")[1]

topic How to add New Rows in Conditional Match jmp 15 in Discussions

How to add New Rows in Conditional Match jmp 15

Re: How to add New Rows in Conditional Match jmp 15