Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    help needed in excel (excel 2002)

    Hi ,
    I have recoded over 8000 items & need help in finding an easier way to review if there are repetitions in the code.Scanning the same individually takes too much time and i tend to loose focus.ANy help would be appreciated.
    Attached is a sample
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: help needed in excel (excel 2002)

    If you need to filter out duplicate records, try Data, filter, advanced filter and check the unique records only box. Tell Excel to copy the results to another sheets and you're OK.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: help needed in excel (excel 2002)

    Thanks,
    Your suggestion worked well and saved me a lot of time
    Thanks again
    jb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •