different values

  1. P

    Count based on two columns, skipping blanks

    Alright, so what I've been trying to figure out for an embarrassingly long amount of time is how to count different values based on two columns, skipping blanks. I've tried a variety of COUNTIF/S and SUMPRODUCT formulas. This is the closest I've come, but it doesn't take into account what is...
  2. MaxWol

    Remove different rows in 2 sheets

    Hi all, I have two sheets. Sheet 1 has 73.619 rows and sheet 2 has 41.470 rows. The values of column A in sheet 2 appear randomly in column A of sheet 1. I want to do 2 things: 1. I want to delete all rows in sheet 1 that have a value in column A that can not be found in column A of sheet...
    • MaxWol
    • Thread
    • column a different values remove rows sheets two sheets
    • Replies: 1
    • Forum: Excel Questions

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