Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Comparing columns

  • 22-12-2017 7:16pm
    #1
    Hedgecutter
    Registered Users, Registered Users 2 Posts: 1,041 ✭✭✭


    Hi I have two columns of ID numbers on a spread sheet, column 1 has ID numbers that have been imputed into and stored with in an ERP management system, column 2 are all the ID number from the customer.

    What I want to do is compare each column and find the ID numbers that are NOT in the management system (column 1).

    I need to find ID numbers that have not been inputted in to the system yet.

    Iv tried Vlookup and match but cant get it to work.

    Attached is an example of the numbers in the columns.

    The actual spread sheets have around 100 ID numbers.

    Any help would be appreciated.


Comments

  • #2
    jus_tin4
    Registered Users, Registered Users 2 Posts: 432 ✭✭jus_tin4


    Hedgecutter wrote: »
    Hi I have two columns of ID numbers on a spread sheet, column 1 has ID numbers that have been imputed into and stored with in an ERP management system, column 2 are all the ID number from the customer.

    What I want to do is compare each column and find the ID numbers that are NOT in the management system (column 1).

    I need to find ID numbers that have not been inputted in to the system yet.

    Iv tried Vlookup and match but cant get it to work.

    Attached is an example of the numbers in the columns.

    The actual spread sheets have around 100 ID numbers.

    Any help would be appreciated.

    Vlookup should work for this, I can’t see the excel so I’ll just try explain the Best I can

    =vlookup(cell1,all of column1,1,0)

    This will return a value if no in col 1 appear in col 2. Return n/a if the number isn’t there


  • #3
    Hedgecutter
    Registered Users, Registered Users 2 Posts: 1,041 ✭✭✭Hedgecutter


    Thanks its is working now, problem I notices is one column is copied from one spread sheet and has blank spaces after the numbers and the other column copied from some one else's spread sheet and has no blank spaces after the numbers.

    Is there a way to paste both the same and remove those blank spaces?


  • #4
    drdidlittle
    Registered Users Posts: 402 ✭✭drdidlittle


    Hedgecutter wrote:
    Is there a way to paste both the same and remove those blank spaces?


    Try multiply number by 1 or else try trim function


Advertisement