+ Reply to Thread
Results 1 to 5 of 5

New number identify by comparing two CELLs data

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    New number identify by comparing two CELLs data

    Dear all,
    I am having some numeric data series in the CELL A2 & CELL B2 , by comparing both cell number data , I need to find out any new number is exists or not if I get new number or number of series then that number need to identify & put it in the CELL C2.
    Likewise, by comparing CELL A2 number data with CELL B2 number data , if any number or number of series does not exist in the CELL B2 then that number need to identify & put it to CELL D2.

    old_list(CELL A2) New_List(CELL B2) New_Number_Found(CELL C2) Number_Not_Found(CELL D2)
    573 589 625 643 625 643 644 644 573 589



    Please find some example data as attached in the excel sheet , I will be happy if I get any solution of my task , excel formula or macro always appreciated.

    Thanks
    Attached Files Attached Files
    Last edited by nur2544; 01-13-2019 at 12:00 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: New number identify by comparing two CELLs data

    Try
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: New number identify by comparing two CELLs data

    Hi jindon,
    Thanks for replay , I put “|” this sign to make data table separation , in the real example it doesn’t exists , I agree it is my fault . however I am editing this , it is better to use my attached excel sheet.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: New number identify by comparing two CELLs data

    What are you talking about?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: New number identify by comparing two CELLs data

    Hi Jindon,
    Yes it works perfectly ! I appreciated it ,you did nice job for me. thanks for your valuable time in this regard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing two cells to provide lowest number.... but....
    By BMAC86 in forum Excel General
    Replies: 8
    Last Post: 12-27-2016, 01:16 AM
  2. [SOLVED] VBA Macro to identify number of empty cells from separate workbook
    By TforTimmeh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2016, 05:13 AM
  3. [SOLVED] Identify Data Range Number
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2015, 04:10 AM
  4. identify errors comparing sheets
    By keshav140 in forum Excel General
    Replies: 3
    Last Post: 08-31-2014, 06:15 AM
  5. Replies: 7
    Last Post: 06-13-2013, 06:56 AM
  6. [SOLVED] Comparing 2 Lists to Identify Differences
    By ORRACLE1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2012, 02:26 PM
  7. comparing two cells that are not number values
    By cheddarthief in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2011, 12:01 PM

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