Not sure what I need
Not sure what I need
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Not sure what I need

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello, I am new to this forum and hope you can help me.

    I have 30,000 rows with 4 columns. I need to put a similar list next to the first column and compare them to see if any in the second column are not in the first column. They are product numbers and I need to have like ones next to each other for a cost comparison.

    Thank you in advance
    Ed.


    [ This Message was edited by: edsjr on 2002-03-28 16:34 ]

    [ This Message was edited by: edsjr on 2002-03-28 18:28 ]

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try using advanced filters.

    The list with four columns is your range and the single column list is your criteria.

    Be sure that the column headings on the range are IDENTICAL to the criteria range

  3. #3
    New Member
    Join Date
    Nov 2007
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Similar issue, but slightly different

      
    I have two columns of data I'm comparing - column A has account numbers of a similar, but not identical format to account numbers in column B.

    What function can I use to determine if the account numbers in column A exist in column B?

    Data example:
    Cell A1 = 670112020112
    Cell B1 = 670112020

    VLOOKUP with a Range_Lookup = TRUE argument doesn't work, as there's no rounding involved here.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com