For some official purpose sometimes we have to use excel. But if any one don’t know excel formulas very much, then its better to convert data to known technology like MySQL.
I know MySQL data query, but don’t know excel query or formula much.
So i used this tool: Excel to MySQL converter.
This tool is very useful and nice.
It easily imports the excel data to MySQL database.
Then for some report i have to collect distinct items with counts.
So i used this query:
SELECT cell, Count(*) As Count From table1 GROUP BY cell Here cell is the column name and table1 is the database table name.