Two tables to manage data

[Deverti]

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

 

[sandy666]

sorry to bother you, but imho you should have these two tables clean (with no any calculations) , connect them somehow (group or merge) then calculate what you want
I can't do that because if the second table is the result so I really don't know how you got these columns: Share Rent Total Rent Actual Building Lease
detailed description is welcome
this is idea only