Spreadsheet: 32685d1228862814-filtering-a-pivot-table-copy-of-mobilephones
Sheet: Report Table

Result | F |  |  |  | Result | F
Count of Bluetooth Code |  |  |  |  | Count of Bluetooth Code
[NAME] | [NAME] | Total |  |  | [NAME] | Total
Nokia 6300 | Nokia 6300 | 90 |  |  | Nokia 6300 | 90
SonyEricsson K750i | SonyEricsson K750i | 36 |  |  | SonyEricsson K750i | 36
Samsung SGH-E250 | Samsung SGH-E250 | 24 |  |  | Samsung SGH-E250 | 24
Nokia E50 | Nokia E50 | 22 |  |  | Nokia E50 | 22
Nokia 6230i | Nokia 6230i | 21 |  |  | Nokia 6230i | 21
SonyEricsson K550i | SonyEricsson K550i | 20 |  |  | SonyEricsson K550i | 20
Nokia N70 | Nokia N70 | 18 |  |  | Nokia N70 | 18
Nokia N73 | Nokia N73 | 18 |  |  | Nokia N73 | 18
Nokia 5200 | Nokia 5200 | 17 |  |  | Nokia 5200 | 17
SonyEricsson K510i | SonyEricsson K510i | 17 |  |  | SonyEricsson K510i | 17
unknown | unknown | 17 |  |  | unknown | 17
SonyEricsson W300i | SonyEricsson W300i | 16 |  |  | SonyEricsson W300i | 16
Nokia 6103 | Nokia 6103 | 13 |  |  | Nokia 6103 | 13
Nokia 6021 | Nokia 6021 | 12 |  |  | Nokia 6021 | 12
Nokia E65 | Nokia E65 | 12 |  |  | Nokia E65 | 12
SonyEricsson K800i | SonyEricsson K800i | 12 |  |  | SonyEricsson K800i | 12
Nokia E51 | Nokia E51 | 11 |  |  | Nokia E51 | 11
LG [NAME] | LG [NAME] | 9 |  |  | LG [NAME] | 9
Nokia 6230 | Nokia 6230 | 9 |  |  | Nokia 6230 | 9
Nokia 6680 | Nokia 6680 | 8 |  |  | Nokia 6680 | 8
Nokia N95 | Nokia N95 | 8 |  |  | Nokia N95 | 8
Samsung SGH-X680 | Samsung SGH-X680 | 8 |  |  | Samsung SGH-X680 | 8
SonyEricsson K700i | SonyEricsson K700i | 8 |  |  | SonyEricsson K700i | 8
LG KE970 | LG KE970 | 7 |  |  | LG KE970 | 7
Nokia 5300 | Nokia 5300 | 7 |  |  | Nokia 5300 | 7
SonyEricsson K810i | SonyEricsson K810i | 7 |  |  | SonyEricsson K810i | 7
Samsung SGH-U700 | Samsung SGH-U700 | 6 |  |  | Samsung SGH-U700 | 6
Nokia 6151 | Nokia 6151 | 5 |  |  | Nokia 6151 | 5
Nokia 6630 | Nokia 6630 | 5 |  |  | Nokia 6630 | 5
SonyEricsson W880i | SonyEricsson W880i | 5 |  |  | SonyEricsson W880i | 5
Nokia 6280 | Nokia 6280 | 4 |  |  | Nokia 6280 | 4
Nokia 6600 | Nokia 6600 | 4 |  |  | Nokia 6600 | 4
Samsung SGH-D900 | Samsung SGH-D900 | 4 |  |  | Samsung SGH-D900 | 4
Samsung SGH-E570 | Samsung SGH-E570 | 4 |  |  | Samsung SGH-E570 | 4
Samsung SGH-J600E | Samsung SGH-J600E | 4 |  |  | Samsung SGH-J600E | 4
SonyEricsson K600i | SonyEricsson K600i | 4 |  |  | SonyEricsson K600i | 4
SonyEricsson W610i | SonyEricsson W610i | 4 |  |  | SonyEricsson W610i | 4
SonyEricsson W800i | SonyEricsson W800i | 4 |  |  | SonyEricsson W800i | 4
LG KE850 | LG KE850 | 3 |  |  | LG KE850 | 3
LG L600V | LG L600V | 3 |  |  | LG L600V | 3
Nokia 6085 | Nokia 6085 | 3 |  |  | Nokia 6085 | 3
Nokia 6310i | Nokia 6310i | 3 |  |  | Nokia 6310i | 3
Nokia 6670 | Nokia 6670 | 3 |  |  | Nokia 6670 | 3
Nokia E90 | Nokia E90 | 3 |  |  | Nokia E90 | 3
Samsung SGH-A717 | Samsung SGH-A717 | 3 |  |  | Samsung SGH-A717 | 3
Samsung SGH-D600E | Samsung SGH-D600E | 3 |  |  | Samsung SGH-D600E | 3
Samsung SGH-E380 | Samsung SGH-E380 | 3 |  |  | Samsung SGH-E380 | 3
Samsung SGH-U600 | Samsung SGH-U600 | 3 |  |  | Samsung SGH-U600 | 3
Samsung SGH-Z370 | Samsung SGH-Z370 | 3 |  |  | Samsung SGH-Z370 | 3
Samsung SGH-Z510 | Samsung SGH-Z510 | 3 |  |  | Samsung SGH-Z510 | 3
Samsung SGH-Z630 | Samsung SGH-Z630 | 3 |  |  | Samsung SGH-Z630 | 3
Group1 = other | LG CU400 | 2 |  |  | Group1 = other | 72
 | Nokia 2630 | 2 |  |  | Grand Total | 611
 | Nokia 2760 | 2
 | Nokia 6133 | 2
 | Nokia 7373 | 2 |  |  |  |  |  | use >pivot table tools >group and show detail > group
 | Nokia E62 | 2 |  |  |  |  |  | select all those with value <3 then right click-group
 | Samsung SGH-D830 | 2 |  |  |  |  |  | You will see what is displayed in columns A B and C
 | Samsung SGH-D900i | 2 |  |  |  |  |  | Then drag column B out of the pivot table and you will
 | Samsung SGH-E390 | 2 |  |  |  |  |  | be left with what is in F and G
 | Samsung SGH-F300 | 2 |  |  |  |  |  | edit any column names you don’t like.
 | Samsung SGH-S400i | 2
 | Samsung SGH-X700 | 2
 | Samsung SGH-X820 | 2
 | Samsung SGH-Z400 | 2
 | Ericsson K610i | 1
 | Ericsson K800i | 1
 | LG KU800 | 1
 | Nokia 6086 | 1
 | Nokia 6110 | 1
 | Nokia 6120 | 1
 | Nokia 6125 | 1
 | Nokia 6126 | 1
 | Nokia 6131 | 1
 | Nokia 6233 | 1
 | Nokia 6260 | 1
 | [NAME] | 1
 | Nokia 6288 | 1
 | Nokia 7370 | 1
 | Nokia 7610 | 1
 | Nokia 7650 | 1
 | Nokia 8800 | 1
 | Nokia 9300 | 1
 | Nokia E61 | 1
 | Nokia E61i | 1
 | Nokia N71 | 1
 | Nokia N80 | 1
 | Nokia N93 | 1
 | Samsung SGH-A707 | 1
 | Samsung SGH-D600 | 1
 | Samsung SGH-D800 | 1
 | Samsung SGH-D807 | 1
 | Samsung SGH-D820 | 1
 | Samsung SGH-E530 | 1
 | Samsung SGH-E840 | 1
 | Samsung SGH-E900 | 1
 | Samsung SGH-T609 | 1
 | Samsung SGH-X670 | 1
 | Samsung SGH-X830 | 1
 | Samsung SGH-Z560 | 1
 | Samsung SGH-Z560V | 1
 | SonyEricsson P1i | 1
 | SonyEricsson P910i | 1
 | SonyEricsson V630i | 1
 | SonyEricsson V800 | 1
 | SonyEricsson W550i | 1
 | SonyEricsson W810i | 1
 | SonyEricsson W910i | 1
 | SonyEricsson Z310i | 1
Grand Total |  | 611