Closed Thread
Results 1 to 3 of 3

Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    81

    Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)

    I am new to use Excel.I am using MS OFFICE PROFESSIONAL PLUS 2010.
    Operating system Windows 7. I have 50 Lacs Local Cell Numbers and i want
    to delete my competitors cell numbers from this big list which is 302 cell numbers.

    I divide this big list into 5 Sheets because each excel sheet allow 1048576 rows.
    The big list is paste in column A and the competitor list is paste on column B.

    Column "A" have all cell numbers
    Range = (A2:A1048576)

    Column B have all competitors cell numbers
    Range = (B2:B302)

    Column C for refine result without competitors

    I want to delete Column B values from column A so what can i do for it.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)

    Hi
    I think if you upload a sample file it will be a great help!!!!

  3. #3
    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

    Re: Delete Cell Numbers of Column B From Column A (Column B Small and Column A too big)

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    With four posts you should know the forum rules.

    Thread Closed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed 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