pick Match Formula Simplify

anwarbham — Sat, 16 Nov 2024 19:15:56 GMT

Im trying to group a set of accounts and with the resulting group assign a new account number.

im using pick match it seem to do the job, but . for every Match i have to add the same new account number

is there anyway of just setting the new account number once instead of repeating the new account number 20 times

example is the formula below. if teh accounts are found in [pnl_code] then assign it 9030000000

thanks

pick(Match([pnl_code],

'3010111100',

'3010111200',

'3010112100',

'3010112300',

'3010113100',

'3010113200',

'3010210000',

'3010220000',

'3010620000',

'3010621000',

'3010631001',

'3010631002',

'3010632001',

'3010641000',

'3010642000',

'3010800000',

'3010910000',

'3010930000',

'3010943000',

'3010944000',

'3010945000',

'3012000000',

'3010115001',

'3010115002')

,'9030000000'

,'9030000000')

Re: pick Match Formula Simplify

DavidM — Tue, 21 Jan 2020 11:56:35 GMT

you can simplify it with:

if(match(your list), '9030000000',original value)

However how about making a table (either xls or inline) and the using applymap?

anwarbham — Tue, 21 Jan 2020 12:45:55 GMT

i was thinking about using applymap might give it a try