Shades,
Sorry - I'm not always good at describing the problem.
Basically, I have a sheet with the names of all our staff and their sections. There are 5 columns (FirstName;LastName;Directorate;Unit;Section) Leaving the names aside for now, the last three columns contain lists of the relevant directorate, unit or section.
e.g. The directorate column has either Chief Exec, Community, Finance or Environment in its cells.
All the cells in each column are filled and are filled with one entry only. What i would like to do is count the number of unique entries and total it at the bottom. I've tried using a pivot table but all I can make it do is count the number of staff in each section but not count the number of sections.
Hope this is this any clearer!
Cheers