excel formula 2016

  1. G

    Removing duplicates rows

    Data Tier Category Name Tier 1 Tom Tier 1 Tom Tier 1 Harry Tier 1 Rafa Tier 1 Daniel Tier 2 Tom Tier 2 Harry Tier 2 Harry Tier 2 CAN ATALAY Tier 2 HANN-WEN SHEU Tier 3 Oktar Tier 3 Miria Tier 3 Harry Tier 3 CAN ATALAY Tier 3 Tom Tier 3 Rafa Tier 3 Oktar...
  2. E

    Excel find which group of nunbers repeating in multiple columnes

    I have 4 columnes with simple values. 31,42,44 appears in every columne. But this is a small sample of data . I need to work with much bigger data. Is there any formula to find which numbers appears simultaneously on all columnes?
  3. U

    Excel Formula: Extract Street Number, City and Zip without Comma

    Hi Gurus, Do you have any idea on how I can easily extract the details for a French address? Example is: SAINT LEONARD 56200 ST MARTIN SUR OUST SAINT LEONARD 56200 ST MARTIN SUR OUST Any help will be much appreciated. :) Regards!

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