Excel 2003 - Comparing Arrays
Posted on 2011-10-09
I have FoRArtsArr with n records by 20 columns. In columns 10, 13, and 16 there can be only one of 157 possible values (these values are always 4-character numeric i.e. 0102, 0906, 1407, etc).
I wish to create a new single column array (RelatedFoRsArr) that contains a unique list of the values in column 10, 13, and 16 of FoRArtsArr except ThisFoR (to be tested in the main routine, not as an afterthought). RelatedFoRsArr should have only as many rows as there are unique values from FoRArtsArr.
Please avoid geek-speak-coding i.e. proper variable names and structured routines so I can understand and modify as needed.
I am not able to check in every day so please anticipate delays in my replying … thanks in advance!