Hello I have a table that I need to return the number of unique rates per person where values are greater than zero and if condition = 1 is true by 2 columns. I'm not getting expected results with array formulaand next question how to sum the unique rates.Please Login or Register to view this content.
test_formula.pngtest_formula.xlsx
Bookmarks