Forum Discussion

John null's avatar
John null
Copper Contributor
Nov 27, 2018

How to code a set of numbers?

Hi,

I am trying to use a key (see attachment , on column G &H ) to code a data set ( A through E) and place on a table (J though N). For example, the first row  in the data set ( A through E) is 10,22,29,31,33 to be coded as 3,1,0,1,0 ( using the key). I tried using the index and match function but with no luck. Please help.

Resources