LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Excel 7.0 - removing duplicates

I am using xl7.0. I have located ribbon & remove duplicates, but cannot seem
to get correct result. I am using it against 6 cols of data. Is that my
problem? I am sure there is something I am obviously doing wrong, but new 2
xl7.0.

Data
Col1 Col2 Col3 Col1_t Col2_t Col3_t
111 2654 1.1 111 2654 1.1
577 2354 90.4 689 2354 541.1
689 2354 541.1 222 2654 2.8
744 1499 31.7

Result
577 2354 90.4
222 2654 2.8
744 1499 31.7
 
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
Removing Both Duplicates from a list tim Excel Discussion (Misc queries) 11 April 21st 09 12:28 AM
Removing Duplicates Danielle Excel Worksheet Functions 5 March 10th 06 07:56 PM
removing duplicates robhargreaves Excel Discussion (Misc queries) 1 July 24th 05 12:35 AM
Removing Duplicates sat Excel Discussion (Misc queries) 5 June 18th 05 11:18 PM
Removing Duplicates sat Excel Worksheet Functions 1 June 18th 05 11:18 PM


All times are GMT +1. The time now is 04:56 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"