Reply to thread

Message: [QUOTE="Ms-Exl-Learner, post: 14016859"] From my point of view using Pivot Table is the best method in this case. Excel 2003:- Select the data and press Alt+D+P>>Click Next>>Now your data will be getting selected with marching ants>>Click Next Once again>>Click Layout>> In the left side of the layout window the column headers will be shown Just drag the heading Number in Row Field and Occurrences in Data Field. Do double click in Occurrences Field from Data and select Count and Give Ok Twice. Select the destination of your report and click finish. Excel 2007:- Select the data and press Alt+D+P>>Click Next>>Now your data will be getting selected with marching ants>>Click Next Once again>> Select the destination of your report and click finish Just drag the heading Number in Row Labels and Occurrences in Values Field. Click on Occurrences Field from Values and select “Value Field Settings” and select count and give ok. Hope it’s clear to you! [/QUOTE]