belgium

  1. K

    Text formula - reverse word

    Hi, I face an issue with imported text over a few hundreds lines: One cell (A1) is like this Belgium BE » Flanders VLG » Antwerp Province VAN » Arrondissement of Antwerp 11 » Antwerpen 11002 and I wish to have Antwerpen (11002), Arrondissement of Antwerp (11), Antwerp Province (VAN), Flanders...
  2. Welsh Mark3

    Creating an order

    I'm looking to create a formula that 'rank' an occurrence in the file, I guess similar to the count function but rather than the number of times it appears, I want where it appears in that range of occurrences. <tbody> Column A Desired Result <tbody> Belgium </tbody> 1 <tbody>...
  3. G

    Vlookup on same column

    Hi everyone, I have a table similar to the following one, but contains thousands of rows. <tbody> Country ID Brazil Belgium Russia Russia 100 Belgium 300 Brazil 200 </tbody> Each cell in column A has a Sale ID in Column B, but some of them are empty (in column B). I would...
  4. M

    Using Index in combination wth Match

    I am using the table below to fill in the right value from another worksheet called "Call Rates". <tbody> A B 1 Type Convesation Fonzer 2 Belgium, Fixed € 0,02000 3 </tbody> The Worksheet Call Rates looks like this <tbody> A B C D 1 Fonzer Fonzer+ Fonzer++ 2...

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