+ Reply to Thread
Results 1 to 3 of 3

Eliminating Identical Values in Different Columns

  1. #1
    Registered User
    Join Date
    05-14-2005
    Posts
    3

    Question Eliminating Identical Values in Different Columns

    I recive my Banks statement..
    I want to reconcile those entries with my own..

    Say I got entries passed by me in

    Column D, from D6 to D220 and entries posted by Bank in H 8 to H 265,

    Now I want to sort and list all the entries common in Column D and H,

    so that I can know which entries have not been posted by Bank and what they have posted is correct.
    Can anyone help pls..?
    Edit >> find is tooo time taking.. and for every entry.. its too cumbersum...
    Can a Macro do..it..?

    Waiting for someone to help me out.
    Sat

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Is this close (see encl. file)?

    Ola Sandström
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-14-2005
    Posts
    3

    Red face Identical Values

    Ola Sandström

    Dear Ola...

    If I may call you..that..
    Thanx for your Help..
    But I would further trouble you...As ..My Data is quite large..I mean number of entries in Bank statements are More then say 750 every time...Hence it is rather difficult to sort entries,, while using the way you suggested..
    I want the Identical entries to be sorted in ascending or Descending order....So that then I can remove them to arrive at the un passed entries...
    Can you please help me out..

    Thank you again..for your advise..

    Y/f
    sat.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1