+ Reply to Thread
Results 1 to 3 of 3

2 columns filteration with condition

  1. #1
    Registered User
    Join Date
    02-20-2008
    Posts
    50

    2 columns filteration with condition

    Hi,

    I have spread sheet in which there are 6800 lines

    In column C i have vendor number (6 digit) and

    In column F i have Invoice numner (both numeric and alpha numeric)

    In oth the columns we have more than one time vendor and invoice number.

    Now i want the list of vendors who have send the same invoice more than once. REMEMBER that some vendors have same invoice series.

    YOUR help will be appreciated.

    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    You're asking us to guess what you mean by 'the same invoice series' and how it should be treated.

    If I understand your request, the most common approach, or at least the one I seem to use most often in cases like this, is to use a helper column which contains the vendor number and invoice number concatenated together. Then you can use a COUNTIF() on the helper column to see how many occurrences of each cell in the helper column, there is in the whole of the helper column. Filter the COUNTIF() column for values >1.

    HTH

  3. #3
    Registered User
    Join Date
    02-20-2008
    Posts
    50
    Quote Originally Posted by Richard Buttrey
    You're asking us to guess what you mean by 'the same invoice series' and how it should be treated.

    If I understand your request, the most common approach, or at least the one I seem to use most often in cases like this, is to use a helper column which contains the vendor number and invoice number concatenated together. Then you can use a COUNTIF() on the helper column to see how many occurrences of each cell in the helper column, there is in the whole of the helper column. Filter the COUNTIF() column for values >1.

    HTH

    THANKS thanks thanks for understanding and suggesting a solution. Thats perfect.

    Just one Q why can't I figure out that option .

    Regards,
    SAN

+ 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