Forum Discussion
IF, AND, AVERAGE help!
Hi All, I am really stuck and would very much appreciate some help, please! I need to find the average of a range of data when there are specific "material" types in two different columns. For exa...
As variant
=GROUPBY(HSTACK(Table1[Secondary Material],Table1[Primary Material]),Table1[% Used], AVERAGE,,0)