alphabetization

  1. J

    Address sorting formula

    Good day all, New to the forum but here goes. I am using Excel 2013. I receive a list of addresses on a daily basis. but the address I receive is only the number of the house. The number determines the community name. example: address 52303-1 belongs in Comanche III community. the "-1"...
    • joesbox
    • Thread
    • alphabetization excel 2013 formula nested "if statements" street addresses
    • Replies: 3
    • Forum: Excel Questions
  2. A

    A little more organization needed

    Hello, I have to make a spreadsheet to track credit solicitation. In column B I have a list of my employees (currently entered alphabetically manually). the next columns (D-O) i enter the number of credits opened for each employee, each month. This is totaled into column Q for a year...
  3. S

    Way to identify items not in alphabetical order?

    I have a large file in Excel 2007 that's ostensibly in alphabetical order. But because it was OCR'd, errors have occurred, and some entries were mis-read. An example would be: <table style="border-collapse: collapse; width: 149pt;" border="0" cellpadding="0" cellspacing="0" width="199"><col...
    • shipindex
    • Thread
    • alphabetical alphabetization conditional formatting data validation
    • Replies: 5
    • Forum: Excel Questions

This Week's Hot Topics

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
Top