Prev Previous Post   Next Post Next
  #1   Report Post  
Happy
 
Posts: n/a
Default Unique Records

I have 3 columns

Name Tel Fax
Ang 93830220 99329207
Boo 93309374 98403803
Coo 99094890 98403803
Doo 84958948 38490384
Foo 74937489 09389099
Goo 43984093 09389099
Hoo 98983490 98439849
Koo 09439489 74837834

How can I make it like this? (ie remove subsequent same fax numbers)

Name Tel Fax
Ang 93830220 99329207
Boo 93309374 98403803
Doo 84958948 38490384
Foo 74937489 09389099
Hoo 98983490 98439849
Koo 09439489 74837834

Thks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filtering for unique records KG Excel Discussion (Misc queries) 7 August 13th 05 06:07 PM
Deleting specific records [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM
Counting Unique Records with multiple conditions Keithlearn Excel Worksheet Functions 4 April 27th 05 12:44 AM
Inconsistent Results: Advanced Filter Unique Records Only KB Excel Discussion (Misc queries) 1 March 25th 05 02:34 PM
Finding unique records from a list. Shanks Excel Discussion (Misc queries) 4 February 24th 05 10:01 AM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"