Hello all,
i have a data which has duplicate entries for same date.
i can get the distinct count of values in column A using a pivot but i also want the sum of only the distinct entries from column B based on dates in column C.
A B C
1 100 15/02
2 600 15/02
3 500 15/02
1 100 15/02
4 200 15/02
6 300 15/02
4 200 15/02
so my pivot as required is
Date |Count of distinct | Sum of distinct
15/02 | 5 | 1700
how can this be achieved in pivot preferably or else the entire thing by formulas.
i have a data which has duplicate entries for same date.
i can get the distinct count of values in column A using a pivot but i also want the sum of only the distinct entries from column B based on dates in column C.
A B C
1 100 15/02
2 600 15/02
3 500 15/02
1 100 15/02
4 200 15/02
6 300 15/02
4 200 15/02
so my pivot as required is
Date |Count of distinct | Sum of distinct
15/02 | 5 | 1700
how can this be achieved in pivot preferably or else the entire thing by formulas.