Pick and Match?

poluvidyasagar — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following situation.

Here is my data:

So in a pivot chart, i would like to get the following:

I tried to use the following script but it does not work. I understand the reason behind but i would like a better logic.

= pick( Match(left(Location,2),'2c'), '2c Setup')

Can someone improvise this logic to get me what i want as the result.

Rightnow, i only get the following as my result.

PN	Setup
34567	2c setup

Thanks,

Vidya

Re: Pick and Match?

sunny_talwar — Thu, 18 Oct 2018 13:34:58 GMT

Try this

=Pick(WildMatch(Concat(DISTINCT '|' & Location), '*|2C*'), '2C Setup')

poluvidyasagar — Thu, 18 Oct 2018 13:38:51 GMT

Awesome.. It worked.

Thanks Sunny