Excel: count unique values using SUMPRODUCT with multiple conditions -
ok, have sum product working give me count of unique values in column: =sumproduct((f2:f38<>"")/countif(f2:f38,f2:f38)) so if have numbers: 1, 2, 3, 1, 5, 6, 2, 5, 2 return 5 . but want count number of unique values based upon number, e.g.: name: sales: mike 2 bob 1 gary 1 mike 5 bob 6 gary 1 mike 3 bob 4 gary 2 mike 1 bob 2 gary 6 mike 3 bob 1 gary 1 mike 1 bob 3 gary 4 it there 4 unique values "name" mike, 5 unique values "name" bob, and 4 unique values "name" gary. because "name" mike there numbers 2 5 3 1 3 1 , unique numbers are 2 5 3 1 and therefore count return 4`. is there way of doing this? here's 1 solution. insert cell @ bottom value trying...