I have a few thousand rows of daily data that show receipts against Purchase orders.
I need to report the number of transactions as well as the number of PO's those transactions were recordered against.
Basicly I need to report the number of different numbers an an array of cells.
The correct answer for the list below would be 9 because there are 9 different numbers listed.
1
1
2
2
3
3
4
4
5
5
6
6
7
7
8
8
9
9
I need to report the number of transactions as well as the number of PO's those transactions were recordered against.
Basicly I need to report the number of different numbers an an array of cells.
The correct answer for the list below would be 9 because there are 9 different numbers listed.
1
1
2
2
3
3
4
4
5
5
6
6
7
7
8
8
9
9