apt

  1. R

    One column converted to two - - HOW?

    If someone sends me a database, with one cell with an entry such as "1234 Smith St, Apt 5" Can it be converted to two cells, one with "1234 Smith Way" and another with "Apt 5" Thanks in advance
  2. D

    Compare Columns to find Duplicates

    Hello all, I have a list with names of individuals and repeat addresses. I would like to find a way Duplicates. Thanks in advance. <tbody> 1 A B C 2 John Smith 2 Main St Apt 5B Duplicate 3 John Smith 2 Main St Apt 5B Duplicate 4 Jason Bourne 5 Rock Road Apt 2B Not Duplicate 5 Jason...
  3. M

    Excel help

    Apt owners would like to be able to search thru apt numbers and return the price of apt. Listed. I need help creating a nested lookup function in cell E3. Look up rental price in column D using the apt unit number in cell B3.what would this formula look like?
  4. J

    Macro Flag Records with Dash Alpha/Numeric

    I have a macro (below) used to clean up a file of addresses. One of my clean steps is to flag any addresses which contain number ranges (i.e. a dash "-"). It was working fine but now that I have a larger file with 10k+ addresses I think I need to adjust to make it less restrictive. Here are 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