exact match only

  1. T

    Exact Index Match Returns a Value when it Should Not

    Hi all, I am working with healthcare data in two different worksheets. In my first worksheet, I have a patient unique ID (which is simply a concatenation of their full name, sex, and date of birth) as well as their medical spend. Due to privacy reasons some patient full names are masked with...
  2. S

    How to get Exact Matches in a Column

    I need a column like this "Exact Match" column where only the duplicate values where the match is exact (Case sensitive) shows True. Please help. Name Exact Match Coca Cola Bottlers Japan Inc FALSE Coca Cola East Japan Co TRUE Coca-Cola Bottlers Japan Inc FALSE Coca Cola East Japan...
  3. K

    Exact matches when using COUNTIFS

    Hi there, I am trying to use the COUNTIFS funtion to highlight duplicate rows. Here is an example of my data: _____A _________B _____C_______D 1 UserID _____Name __Licence__Duplicate? 2 ABC1 ..............Joe ........1CL** ......=COUNTIFS(A:A,$A2,C:C,$C2)...
  4. N

    Filtering out exact acronyms

    Hi all, I have a (probably pretty stupid question) I work a lot with cleaning internal databases . I often have to filter out to particular job titles and one I always have a problem with is "IT" so that would be say and IT manager, a HEad of IT, an IT analyst etc etc etc (endless number of...
  5. E

    Vlookup picking up random data and not exact match

    hi all, I can't seem to fathom this one. i have work book with a basic vlookup(a1,'sheet2'A:G,4,0) where a1 is a string of digits 345678 Sadly the vlookup retruning random answers pretty much where 3,4,5,6,7,8 are present in the sheet I thought 0 returned exact values only.. Where am I...

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
Back
Top