Duplication number with formula help
Soth
If you have a million lines, you must be using Excel 2007. So,
highlight your data, click Insert, then Table. Your data will be a
table, and it will have some nice formatting. The click on Table
Tools; then Remove duplicates will be an option. After you pick that
you will have a form to allow you to select what columns must match to
constitute a "duplicate". Then click okay, and the duplicates will be
gone.
Good luck.
Ken
On Jun 26, 3:45*pm, Soth wrote:
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
|