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"...
  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...

Some videos you may like

This Week's Hot Topics