Prev: Can I use an "=" in Excel 2007 cell without making it a function?
Next: how do I unmerge an entire spread sheet in excel?
From: remove dupplicate entry remove dupplicate on 29 Jan 2010 23:12


"wonderbug" wrote:

> 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
 | 
Pages: 1
Prev: Can I use an "=" in Excel 2007 cell without making it a function?
Next: how do I unmerge an entire spread sheet in excel?