Haddii aad rabto in Excel uu soo bandhigo kaliya diiwaanada buuxiya shuruudaha qaarkood, ka dibna isticmaal filter. Tan awgeed:
- Guji unug kasta oo ku jira kaydka xogta
- On the Advanced tab Data (Xogta) guji Filter (Sifee). Falaadhooyinku waxay ka muuqdaan cinwaannada tiirka.
- Guji falaarta ku xigta ciwaanka Country.
- Guji khadka Xulo dhammaan (Dhammaan dooro) si aad u nadiifiso dhammaan sanduuqyada hubinta, ka dibna calaamadee sanduuqa USA.
- Press OKNatiijooyinka: Excel kaliya waxay tusinaysaa xogta iibka Mareykanka.
- Guji falaarta ku xigta ciwaanka quarter.
- Guji khadka Xulo dhammaan (Dhammaan dooro) si aad u nadiifiso dhammaan sanduuqyada hubinta, ka dibna calaamadee sanduuqa Qtr 4.
- Press OKNatiijada: Excel kaliya waxay muujinaysaa rubuci afraad xogta iibka Maraykanka.
- Si aad u tirtirto shaandhaynta, tabka Data (Xogta) guji nadiifi (cad). Si aad gabi ahaanba meesha uga saarto shaandhada, ie ka saar fallaadhaha, mar kale taabo badhanka Filter (Sifee).