Sprinkler Systems Uhaul move Lawn care Roses and trees Ford Parts Chrysler Parts Lake Powell New IPod Touch Apps New IPhone Apps IPhone Apps IPad Information IPad Apps Android APPS Android Games APPS Android Systems Android Tablets APPS and Beyond Smartphone Apps Smartphone Games Apps Repair and Tools Tablet PC Car Sharing Car Leasing Tabler Pc Fly Fishing Toyota Cars Vacation Rentals Stock market NYSE SSE Stock Freight & Shipping News Gluten Lactose Gout My Coupon Life Campgrounds Check Outdoor Kitchen Design and Redoo Bath Remodeling Palm Springs Las Vegas Vacation Tipps Lake Powell Boating Homes for lease Electric and green Car Blog Pearls and diamonds Whatsapp and forget SMS Blog, What is Whatsapp App Renovation Blog Condo for rent or lease Solar Panel Solar Energie Sun Power Blog Truck for Sale Reconstruction Blog
Computers » microsoft.public.cn.office » 如何挑选重复出现的内容?
如何挑选重复出现的内容? [message #191043] Mi, 12 April 2006 04:35
??!  
统计人员报表时,有人员姓名重复的出现,如 何把这样重复出现的内容很快挑选出来?
Re: ѡظֵݣ [message #191045 ] Mi, 12 April 2006 04:51
cola  
ʽ

--
ʼ!
"" <??! [at] discussions.microsoft.com> дʼ
news:400C2116-B3A9-4523-BAA1-A19B6D8473E8 [at] microsoft.com...
> ͳԱʱԱظij֣ΰظֵ ݺܿѡ
RE: 如何挑选重复出现的内容? [message #194783 ] Do, 27 April 2006 07:19
office  
选中数据区(包括标题行),单击“数据→筛 选→自动筛选”,标题行每一单元格出现倒立 的“▲”,单击“人员姓名”单元格处的“▲ ”,在单击下拉列表中的“包含”或“等于” 或直接在下拉列表中选择要显示的人名,工作 表中显示的将只有该人名的数据行,要显示另 一人名重复操作即可,要全部显示单击“▲” →全部或点击“数据→全部显示”即可。
--
我爱Office


“求助!”编写:

> 统计人员报表时,有人员姓名重复的出现,如 何把这样重复出现的内容很快挑选出来?
Vorheriges Thema:没有安装光盘如何安装更新补丁?
Nächstes Thema:请问,在EXCEL里怎样重复引用上一
Gehe zu:
  


aktuelle Zeit: Sa Mai 26 09:33:29 CEST 2012

Insgesamt benötigte Zeit, um die Seite zu erzeugen: 0,02228 Sekunden
.:: Startseite - Hinweise - Impressum ::.

Powered