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: 55
Default Duplication number with formula help

I have a million lines. There are so many duplications number and cost and
I'd like to keep just ONE number and cost line of any duplication. The rest
of the duplications number will delete. Please see below. Your help with
formula is greatly appreciated.

Regards,
Soth

A B
Number Cost
65663 189,941.00
65663 189,941.00
65663 189,941.00
65663 189,941.00
65675 871,281.00
65675 871,281.00
65675 871,281.00
65675 871,281.00
65934 9,398,216.00
65934 9,398,216.00
65934 9,398,216.00
66430 458,388.00
66430 458,388.00

 
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
Dysfunctional Formula Duplication Across Cells JohnH Excel Discussion (Misc queries) 3 March 18th 08 09:44 PM
Duplication PMST Excel Discussion (Misc queries) 2 February 19th 08 03:18 PM
MS: Excel: Formula for data duplication between sheets? Johnz414 Links and Linking in Excel 4 January 13th 08 09:24 AM
Duplication Welthey Excel Discussion (Misc queries) 2 January 15th 07 09:48 PM
Stop Number duplication in a range Nu-bEE Excel Discussion (Misc queries) 5 March 21st 05 04:23 PM


All times are GMT +1. The time now is 07:10 PM.

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

About Us

"It's about Microsoft Excel"