Sorting Data in Excel

Hi All

I have an excel file that contains 39,000 rows of data and looks like this:

Mobile Number | IMEI | ID Number | Sale Channel

There are multiple Mobile NUmbers, ID NUmbers and Sale Channels for each IMEI.

For each IMEI i want to make a table which lists how many mobile numbers, ID Numbers and Sales channels are there liek this:

IMEI 1 | 11 | 11 | 3

same IMEI are listed multiple times (in rows) for different mobile numebrs, ID numebrs, etc.

Teh best i can do is filter IMEIs together and then count teh rest of the data for each IMEI. But for 39 rows, it seems impossible.

Can someone guide me how i can do this using formulas. I dont know much about formulas so if you give a solution can you please make it simple and easy?

Thanks a lot people!

Hi can you attach sample workbook so we can help you.

I have attached some data from the file. Just 2 IMEIs to give you an idea.