Thanks Divakar. Fantastic application of logic to get the output.
Regards,
C.G.Kumar
On Tue, Feb 8, 2011 at 8:14 PM, Divaker Pandey wrote:
> hi,
>
> Please find this one
>
>
>
> On Tue, Feb 8, 2011 at 10:10 AM, C.G.Kumar wrote:
>
>> Thanks sir,
>>
>> It works.Could you please elaborate the st
select all data and use data tab in excel 2007 or 10 then use remove
duplicate uncheck all columns check only staff # & basic.
Regards,
Aamir Shahzad
On Mon, Feb 7, 2011 at 10:58 AM, C.G.Kumar wrote:
> Please find attached file where i intend to extract only unique records in
> column C (Basic)
Wow Rajan... that was very simple...
Regards,
Manoj Kumar
On Mon, Feb 7, 2011 at 10:27 PM, rajan verma wrote:
> Hi
> Find attachment
>
> Rajan
>
>
> On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wrote:
>
>> Hi C.G,
>>
>> A little complex but hope this might hel
Thanks sir,
It works.Could you please elaborate the steps in the formula, if possible.
Regards,
C.G.Kumar
On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar
wrote:
> Hi C.G,
>
> A little complex but hope this might help your needs...
>
>
> Regards,
> Manoj Kumar
>
>
> On Mon, Feb 7, 2011 at 2:42 PM,
Sir,
Thanks for the solution.However, unique records are not as required.This is
due to the fact that you have considered all column e.g. Basic, Ser Wght,
FPI, WRI,DPAY etc, whereas required unique records is for Basic records only
for particular column.
The solution suggested by you is very inn
Not getting required result as i have to filter by two criteria ;1. staff no
and 2. Basic. Same staff no may have different basic over period of time.
After selecting unique records also, the output so generated is same is base
records.
Further, unique records does not works as two person may hav
use advance filter
1 select col a,b , c goto data- > advance filter
select unique records and click on copy to another loaction and select the
destination cell
On Mon, Feb 7, 2011 at 11:28 AM, C.G.Kumar wrote:
> Please find attached file where i intend to extract only unique records in
> c
Hi Ashish
Thank you ... You made it very simple. I was finding it difficult to loop.
Thanks Omar for the input.
Thanks and Regards
Umesh Dev
On Sat, Jan 15, 2011 at 9:53 PM, ashish koul wrote:
> check the attachement see if it helps
>
>
> On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev wrote:
>
>
Range("a:a").RemoveDuplicates 1, xlNo
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Saturday, January 15, 2011 6:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unique records
check the attachement
check the attachement see if it helps
On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev wrote:
> Hi All,
>
> Can anyone help me with the code in *VBA *to find unique values and
> pasting it separately in Excel.
>
>
> Regards
> Umesh Dev
>
> --
>
> --
Hi All,
Can anyone help me with the code in *VBA *to find unique values and pasting
it separately in Excel.
Regards
Umesh Dev
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
11 matches
Mail list logo
