Job Costing Categories

Problem

Do cost categories need to be in alphabetical order in the job costs sheets?

How about in office cc sheets used in MacNail construction accounting software?

Diagnosis

no. no.Job cost categories can be in any order.

Solution

In both cases we use Formula.find() rather than a lookup(). It will find the first item in column 1 that exactly matches the category text, if no exact matches it will skip and give a *bad cat message. So there's no need to be alphabetical. In fact, MacNail categories themselves are not strictly alphabetical, since AA is not between A and B.

Comments

Entered 10/23/92 by Dennis. Updated 11/20/2010.