Hi there,
I UNDERSTAND your task to mean: from the codes on the 4 columns of one tab / worksheet with 900 cells, WE CREATE A SYSTEM to get codes from another tab (containing the full list of codes) and these codes must fall between the upper and lower codes.
Then, prepare a table in CSV format, and the rows of the table will comprise of all possible combinations of codes in 1 column multiplied by (similar) codes in another column. (I hope to get a clearer picture).
I am very confident that I can help you with the codes and table creation as I am a hands-on, experienced, advanced Excel expert, with adequate knowledge of Excel formulas and functions, including VBA and data manipulation. I have skillfully handled several complex Excel tasks with results.
I do top quality work. I offer unlimited and prompt revisions until my valued clients are completely satisfied.
Willing to work with your rate as I give you maximum job satisfaction.
Reach me via chat, send in the files. I am available to give you results.
Thanks.
Nosakhare E.