comparing lists

  1. B

    Comparing Two Contents Of Two Lists

    Hello - I applied a conditional formula =SUMPRODUCT(--ISNUMBER(SEARCH(Fortune_List,B2)))>0 to my list and I believe it worked. However, my first list has 45000 rows in it so I can filter by color to check and make alterations to the list. ? How can I filter by color, 45,000 rows? Thank you
  2. R

    Help On: Comparing lists by rows with multiple columns and cells with different data types

    Hello kind strangers ~ I need some help with the following scenario in Excel... There are two lists in separate workbooks that need to be compared, Master List and Sample List. The rows in the Master List need to be matched exactly to the Sample List, which has more rows but same number of...
  3. M

    Comparing 2 Lists And Extracting Unique Results

    Hi all On a pretty regular basis I run into this problem, so I finally thought I'd see if the community can help me solve it. I'd like to take 2 separate lists and be able to extract a 3rd list of all entries not present in both lists. For example: List A has 2,500 entries List B has 2,700...
  4. M

    Comparing two lists. . . simpler than I'm making it

    Hello friends, I have two lists of names. The lists are identical except one is more updated (some data has been removed). Specifically the more recently-updated list has 135 fewer names on it. In Column A I have the updated (shorter) list of names, in Column B the older list that is longer...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top