How do I filter names in Excel to eliminate repeats?－software｜痞客邦

Sep 23 Tue 2008 20:46
How do I filter names in Excel to eliminate repeats?

close

I have a list like this:

John Doe
John Doe
Mike Martin
Nancy Smith
Nancy Smith
Nancy Smith

I want to get it like this:
John Doe
Mike Martin
Nancy Smith

John Doe
Nancy Smith
Nancy Smith

Have a look at Menu Datagt;Filtergt;Advanced filter (no dupes)

HTH
--
AP

quot;Scottquot; gt; a écrit dans le message de news:
...
gt;I have a list like this:
gt;
gt; John Doe
gt; John Doe
gt; Mike Martin
gt; Nancy Smith
gt; Nancy Smith
gt; Nancy Smith
gt;
gt; I want to get it like this:
gt; John Doe
gt; Mike Martin
gt; Nancy Smith
gt;
gt; John Doe
gt; Nancy Smith
gt; Nancy Smith

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Hiding Rows in a VBA macro
此分類下一篇： How do I get to the last line of a large spreadsheet to add data
上一篇： Deriving mathematical equations
下一篇： Changing cell from formula to data.

歷史上的今天

2008: Selective Column deletion
2008: Interpolation
2008: How to drag and autofill a non consecutive range of cells?
2008: microsoft office excel cannot paste the data
2008: In EXCEL copy sheet layout to another sheet
2008: 'circular reference'
2008: Invert a matrix larger than 52 x 52 using MINVERSE
2008: Scroll bar Screen tip on Excel 2003 discontinued?
2008: Printing many columns but few rows
2008: ###??
2008: To add a label name on several sheets
2008: Getting Pivot Tables to automatically sort rows in alphabetical order
2008: Format Row If Cell Contains Even Number
2008: In desperate need of help....
2008: How do I put multiple pie charts on one page?
2008: Calcualted Fields in Pivot Tables
2008: Saving worksheets within workbooks as individual files
2008: I can not save archive file in excel
2008: How to chnge 35 relative cells to 35 absolute cells at one time.
2008: Save as Macro in excel
2008: how to put a loop in a macro?
2008: how do i print booklet format in excel?
2008: How do I have information transfer from page to page in excel
2008: Printing gridlines with empty cell
2008: Command Button protection problems????
2008: Format cell color based on multiple cell values
2008: template to use to track employees
2008: explain purpose of {}
2008: merging two files
2008: need a excel spreadsheet for fleet maintenance
2008: smart tags and stock updates
2008: Excel Pivot chart
2008: Importing From one Workbook to Another
2008: having the chart NOT count zero
2008: Please help with Statistics Formulas in Excel
2008: Worksheet formulars
2008: I WANT TO REPEAT SOME CELLS AT THE TOP OF THE SECOND PAGE
2008: Vertical search and NULL
2008: Stop calculating on open
2008: How to select and print custom data (eg: cell value) in excel head
2008: Problems with date input
2008: how do I create a dropdown menu
2008: How to control chart properties from worksheet
2008: pasting to powerpoint
2008: Changing the quot;Licensed toquot; name in microsoft office
2008: Need help with automating the updating of a function in worksheet
2008: Macro To Change Cell Color (Continued)
2008: How can I type 2 effictive formula in one cell?
2008: Workspace amp; Links referenced when workspace opened.
2008: default Comment Font?
2008: Open Outlook with generic message
2008: Copying and pasting data muiltiple times
2008: sum of 1 column if info in another = specific text
2008: Lookup dates, fiscal period table
2008: Can you sort sheet tabs in a workbook
2008: countnonblank
2008: Excel User Conference
2008: Custom Views
2008: automatic updating of javascript downloadable data
2008: Double LOOKUP? Help please...
2008: Copy data into/from textbox
2008: Preventing an excel file from being deleted by another user
2008: how tell if cell has formula
2008: How do I solve the error this #VALUE! error
2008: Time Cell help
2008: Why not automatically updating calculations?
2008: rounding values in in array before sum
2008: Sort a database
2008: ? Hyperlink; reference not valid ?
2008: Excel should automaticaly update a feild when printing ex:Version
2008: small quot;sumquot; function usually located @ LR screen is gone
2008: How to find a row in a sheet and compare the complete row /w origi
2008: Why does Excel 2003 now show Open (Native) option?
2008: data validation
2008: Autofiltering for partial matches
2008: OR Function with more than 30 arguements
2008: Pass or Fail (green or red) criteria for cell?
2008: functions
2008: I cannot load Excel from Office, a problem creating XLStart?
2008: Page numbering question
2008: Saving Large .xls file to external drives
2008: Please HELP!
2008: copy cell from one sheet of worksheet to another sheet
2008: Trouble with a VLOOKUP formula
2008: Huge Files Dont Know Why
2008: macro adding formula to new sheet
2008: How can population pyramid made in excel ?
2008: combining two woeksheets into one
2008: how do I use conditional formatting for alternating cell shading?
2008: Limit of records when using auto filter
2008: Changing cell from formula to data.
2008: How do I hyperlink files in a workbook?
2008: Conditional Sorting
2008: Where can I find a sample of a small business loan proposal?
2008: Conditional Formulas
2008: If statements
2008: How do I get to the last line of a large spreadsheet to add data
2008: Hiding Rows in a VBA macro
2008: what function to use?
2008: plot data on two axis at the same time, metric and english units

留言列表

站方公告

活動快報

【船井...

newdirect

船井生醫推出專門針對高度用眼族、輕熟齡者的葉黃素... 看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)