If I do a departmental print, how can I show the column header as a department description instead of the department number?

=TRIM(DEPARTMENT(0)) give you the Department Code or * as a result.

=TRIM(DEPARTMENT("100")) will return the description for department 100

If E6 = 100 and Department 100 description is East Coast then

=TRIM(DEPARTMENT(E6)) will return East Coast

Hi Eva,

The formula =DEPARTMENT(1) will return the description of the department selected in the toolbar or by the Department Print function, and can be used in the top of each statement or any cell as desired. Use TRIM (as Michael indicated) if you need to get rid of leading or trailing spaces.

You have asked about putting the department description as a column header. Certainly the above will work, as will Michael's examples - just wondering how this fits with the Departmental Print function? Usually column headers indicate that you want to compare multiple departments, something that the Departmental Print function is not set up not do - generate a single statement comparing all selected departments.

The idea is to be able to select any combination of departments to report on. The number and selected departments the reports are run for could be differenct every time.

Then =DEPARTMENT(1) is what you want for your Heading