match a with b

  1. E

    Compare first 3 characters in 2 columns

    Hello everyone, I'm kind of in a pickle. So here's what I need: <colgroup><col span="3"></colgroup><tbody> A B C R5 R6L+ FALSE R5 R6L+ FALSE R5 R6L+ FALSE R5 R6L+ FALSE R6L R6L+ FALSE R5 R6L+ FALSE R5 R6L+ FALSE R6L R6L+ FALSE R6L R6L+ FALSE </tbody> So there are my...
  2. V

    Count matching values from cells across a column and a row

    Hi, I'm trying to count the number of occasions when a cell in a specific column matches a corresponding cell in a specific row. So, going down the column, is there a "1" in the column and a "1" in the same position while going across a row? In other words, if the first cell in the column range...
  3. T

    if A match with B, show result C

    Trying to solve this with function. If A match with B, show result in C. <tbody> column A column B column C 600 50 100 600 TRUE 150 600 TRUE 200 201 332 600 TRUE </tbody>

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