compare cells in columns

  1. A

    Comparing Cells in a row, Columns (> than 10) and checking if adjacent cells have same cell value

    Hi all, Problem: My maximum Range is around 10000 Rows x 365 columns, I want to compare cell values across a row . Conditions: It has to return how many times a name is repeated in each row for every primary key if a name comes only once in a row, that need not be shown...
  2. P

    Help with a long IF,ISNA,INDEX,MATCH formula

    I have this very very big list of almost 700K rows and about 30 columns of data. I have a somewhat working formula to do what I want but it doesn't really work 100% of the time. The data is of all purchases done during a set period and I have a formula that determines what type of purchase it...
    • patrik116
    • Thread
    • compare cells in columns if formula index lookup match
    • Replies: 1
    • Forum: Excel Questions
  3. C

    Match & Highlight pairs of data in 2 columns ignoring duplicates

    Hello, I have a problem that I need some help with. I have data in 2 columns and I need to highlight all the amounts that match the list, looping down the list each item at a time, and once the amount is matched (paired) to continue the loop but disregard the paired (matched) items; even if the...

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