EXCEL function working like SQL group by + count(distinct *)?
- by Solo
Suppose I have an EXCEL sheet with below data
CODE (COL A) | VALUE (COL B)
==============================
A01 | 10
A01 | 20
A01 | 30
A01 | 10
B01 | 30
B01 | 30
Is there an EXCEL function working like ..
SELECT CODE, count (Distinct *) FROM TABLE GROUP BY CODE
CODE | Distinct…