paris

  1. G

    VBA Find and Select loop

    I have the below line of code as part of my VBA . As shown below, the first "find " section looks for the word "Paris". When it finds the work Paris, it updates the cell value as France and then moves on to the 2nd "find" section where it looks for the word "London and then updates the cell...
  2. R

    duplicate detection formula or vba macro

    I have a table in the following manner (let's say they are positioned from columns A to D) <tbody> ID Name Ref # Location 407 INVTF 100900 Paris 789030 New York 541001 Madrid 800 KLUMM 103990 Hong Kong 102030 Toronto 100900 Paris 750 JSIUI 130990 Montreal 657899 Miami...
  3. K

    Need to Combine Rows

    In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B)...
  4. L

    quick way to do Go Special-->Column diff

    Hi I have long column which look like the one below. I want to go to next city fast, so I want to use Go to Special. I tried the following Ctrl + G then Alt + S then Alt +m Ok I can go to next city but how about going to next city, if i repeat all steps above that is slow? I was thinking I...
  5. A

    Combo Box Depend on TextBox Value

    Hello Everyone, I have two option button : London_Click() and Paris_Click() One text Box : TextBox1_Change() One combo box: DropDown_Change() Under the Combo box I have below items: "High London" "Low London" "High London 2" "Low London 2" "High Paris" "Low Paris" "High Paris 2"...
  6. F

    Formula to count consecutive values in a range

    Hi Everyone, I have you can help me, I need a formula to count the latestconsequetive times a location is in a range. Example below: <tbody> Jan Feb Mar Apr May June July Aug Sep Oct London London...
  7. S

    Keeping Appended Data In Sync After Data Connection Refresh

    I have a table with two columns in Excel: <tbody> A B 1 United Kingdom London 2 United States of America Washington DC 3 France Paris 4 Spain Madrid 5 Japan Tokyo </tbody> Column A is populated by an external data connection from a CSV file. Column B is data that I then manually...
  8. M

    VBA. Delete row in a range if Values in Column A do not equal Cell B2

    I am very rusty on VBA and need some help! I need to delete rows within a range (rows 6 to 85) if the value in Column A does not equal B2. I have pasted some example data below <colgroup><col><col><col><col></colgroup><tbody> A B C 1 Currency GBP 2 Employee Charlie 3 4...
  9. U

    SumIF with range across columns and rows

    Hello everyone. I am trying to do a SUMIF where the range consists of multiple columns and rows rather than just a single column. for example: <tbody> A B C D 1 Store 1 Store 2 Store 3 Store 4 2 London Chicago Paris 5 3 Paris NY Ottawa 18 4 Edinburgh Ottawa Paris 21 5 Edinburgh...

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