sky00221155 Member

Hi, After the duplicates function some of the data was lost since for the reference table, there are some attributes that have same primary key value. I tried to add a second primary key column to make the match more specific, but it doesn't seems to find any result.

Yes, I try the AVG function. It was showing the wrong result at first, however, after clean up some cells, the AVG function actually works now. Thank you so much for the help!

Thank you! That helps a lot.