miami

  1. 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...
  2. ExcelNooberino

    If neither

    Hello all, hope you're doing fine.. So I made this dashboard with some data I insert every once and a while, and in the table that contains all that data I have two columns stating the some locations. It's a simple table where I insert the pickup location in one column and the delivery location...
  3. K

    Copy row when a certain value is on Sheet1 to Sheet2

    Hi I am new to VBA. and need a lots of help to make it work. The first Sheet (Everything) got everything, and when i put a value under department like Miami then i want to copy the entire row to my Sheet called Miami. And so on. I have googled it and watched some youtube, but i cant figure out...
  4. Z

    VBA Macro for Userform

    I have an excel workbook that I have made a userform for. My plan for this form is to have the user pick a location from the first combo box and pick another location from the second combo box. After picking these two locations the user will click the run button to run the macro. Example of...
  5. W

    How to to count unique text in a column- and two specific text

    Hello. I use this formula to count unique text in a column and it works well: =ArrayFormula(SUM(IF(FREQUENCY(IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""), IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""))>0,1))) resulting in 6. But the cells in the column also contain the word "Sea" or "Freedom" followed by a...

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