Hi
i have trouble to get a formula to count unique values based on multiple criteria
I get it this formula to work
If the data looks like this:
1022-26, 2014-01-01
1022-26, 2014-01-01
1022-26, 2014-01-02
1022-26, 2014-01-02
It will count the unique value correct to 2.
But how do i add another criteria (for FM) ?
FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-02
FM, 1022-26, 2014-01-02
This should also results in 2.
sample workbook: test.xlsx
Best regards Petter
Bookmarks