matching data

  1. R

    Comparing similar values in Excel

    Hi, I'm a fairly average Excel user but I'm trying to find out how to compare same and similar data in a worksheet to calculate their similarity as a fixed percentage. For Example..... HROR11 and HROX11 are codes that represent a 75% similarity in terms of what they represent but does...
  2. J

    How to automatically populate based on a match from another worksheet.

    Ok, here goes... I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a 'Talent Profile' form (also created in Excel) that I give to HR...
  3. M

    help extracting matching data

    If i have data in columns G through I, I want to be able to find all matching data, put in sort order, filter, etc. and post to a column. Unfort I dont know pivot tables, but pretty good with excel. Here is an example http://www.crlaurence.com/adv/example.pdf This example shows what it would...

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