Closed Thread
Results 1 to 2 of 2

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
    Forum Moderator 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
    28,419

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

    Stop spamming, this is about the fourth in the last few minutes.
    Richard Buttrey

    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