im at a loss here and describing it might be more confusing than simply presenting my dilemma, eitherway...
i feel like it s easier to simply explain my current scenario than attempting to get the concept across:
there s a col "groups" with certain "properties" in another col, which then display "liability" in yet another. Problem now being that some have multiple "liability" entries, so there are duplicates of the "property" value.
i used index and match to showcase distinct values in a second table, to reference data (which mustnt have duplicates to insure validity) to the "property" entry...which was fine until i realized that the index and match array list doesnt seem to be connect to any rows in the second table (e.g. if i sort my data in table 1 only the index&match array changes in table 2, messing up the entire data in the process).
if there s any way to somehow link two tables and create a column with only disinct values so it can be used to reference the tables both ways for formulas, that would be amazing.
link to an example file: /tmp/files - Temporary File Hosting
i feel like it s easier to simply explain my current scenario than attempting to get the concept across:
there s a col "groups" with certain "properties" in another col, which then display "liability" in yet another. Problem now being that some have multiple "liability" entries, so there are duplicates of the "property" value.
i used index and match to showcase distinct values in a second table, to reference data (which mustnt have duplicates to insure validity) to the "property" entry...which was fine until i realized that the index and match array list doesnt seem to be connect to any rows in the second table (e.g. if i sort my data in table 1 only the index&match array changes in table 2, messing up the entire data in the process).
if there s any way to somehow link two tables and create a column with only disinct values so it can be used to reference the tables both ways for formulas, that would be amazing.
link to an example file: /tmp/files - Temporary File Hosting