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...
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>...
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...
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 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.