Re: Deleting unique cells in two lists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi LilyLilyRose,

See Chip Pearson at:

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

See particularly the sections entitled 'Extracting Values Common To Two
Lists' and 'Extracting Values On One List And Not Another' at the foot of
that page.


---
Regards,
Norman



"LilyLilyRose" <LilyLilyRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:803CE85F-7E9C-4852-BFEA-4BE10E408E6E@xxxxxxxxxxxxxxxx
I have two very large lists in an excel spreadsheet. I'd like a way to
delete
cells in one list that aren't located in the other list. For example I
have
A1:A1000 and B1:B1500. There are 500 extra cells in column B that aren't
located in column A and I would like to remove those extra 500. Is there a
formula or a macro that I could use? I have some experience with macros
and
almost no experience at all with visual basic. I'm using Excel 2002.


.

Relevant Pages

  • Re: [ANN][SoC] Ariel 0.1.0 released
    ... This is because of the way it checks for nesting when extracting label tags, ... Can Ariel correctly identify footnotes and pull in the text ... have:verses in your example above. ... lists with more than 5 children). ...
    (comp.lang.ruby)
  • Re: MuPAD: eigenvalue extraction from a list of sub-lists
    ... map, op, 2) for respectively extracting the ... multiplicity and the eigenvalue sub lists generated by the ... I am trying to extract the eigenvalues, ...
    (comp.soft-sys.matlab)
  • Re: Comparing two columns with email addresses
    ... Extracting Values Common To Two Lists ... I am trying to compare two columns that contain email addresses. ...
    (microsoft.public.excel.programming)
  • Re: Duplicate values
    ... See Chip Pearson's duplicate page for a varirty of techniques: ... Extracting Values Common To Two Lists ... Extracting Values On One List And Not Another ... > amount taken to the bank and when. ...
    (microsoft.public.excel.programming)
  • Re: f---ing typechecking
    ... because, eventually, you end up turning them into lists anyway ... I end up extracting them to separate variables. ... If they are eventually extracted to lists, ...
    (comp.lang.python)