province

  1. B

    how to make a vlookup with multiple conditions

    A vlookup with one condition is simple enough. How would I do a vlookup to get me the cost of smth in the province of Ontario that is 10 KM away? <tbody> Province Distance Price ON 5KM $5 ON 10KM $10 Quebec 5KM $15 Quebec 10KM $20...
  2. B

    how to best summarize this in a pivot table?

    <tbody> Province Postal Code Shipping Net Ontario M4M 1L4 $3 Ontario M4M 1X5 -1 Ontario M4M 3Z7 -50 BC Y3L 1Z4 -30 BC Y3L 1X5 -300 BC Y3L 1M9 -700 </tbody> I have about 200K rows of transactions, to a whole set of postal codes. I'm...
  3. S

    Copy then paste to specific cells where criteria matches

    Hello everyone! I have an excel file where some data is provided by other teams (call this the "Source"). I need to take this information and copy it to specific columns in another excel workbook (not worksheet) (call this the Destination) where the Province matches in both worksheets. I am...
  4. 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...
  5. K

    Automatic Dataset Cleaning for Blanks

    Would appreciate some help please. I have quite a large dataset that gets updated on a monthly basis (100,000 rows +). There are 4 unique provinces each 10 unique counties in each province. The users that enter data into the form - using drop down boxes - that generates these fields (among...
  6. A

    Extract province (list included in different sheet) from Address (Advanced fussy search)

    Pls find the attached file. https://drive.google.com/file/d/1gEUX8QJ8rugKYACuYRISCAI3MmWlOM5i/view?usp=sharing What im looking to get is province name in coloumn B of "Address" sheet. Province names are listed in the sheet "Province" Any help is greatly appreciated. Thanks for your time.

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