Make lists of names of people who need training / Remove blanks from lists of names

Hi everyone,

I have a spreadsheet table with a list of names down the left side, and a list of required training events across the top. At the intersection of the name and training event is a cell with the date the training was completed.

What I'd like to do with this is create a separate sheet that gives me a list, organized by training event, of the names of the people who have not completed that training.

For example, if this is my little spreadsheet:


_________security______marketing_______HR policy
Bill_______1/19/10_______1/5/10
Sally______1/1/10______________________2/13/10
Jim________4/1/10______________________2/1/10
Jane_______3/5/10_______ 2/21/10

What I'd like to have is this:

security_________marketing_________HR policy
_________________Sally______________Bill
_________________Jim________________Jane

or this:

marketing ________HR policy
Sally_____________Bill
Jim_______________Jane

so I can determine who needs to be at each training event. I have about 150 people and about 75 training events to track, so what I've been doing: filtering, copying and pasting, is labor intensive to say the least.

I have a mail merge document that lists training dates by individual, so each person can get a memo detailing which training they've done and which they need, but the department head wants a roll-up of requirements by event so the training can be scheduled, rosters generated, etc.

I think of myself as an intermediate user, but I'm not really literate with macros. I can type in a macro from detailed instructions, but I think in formulas rather than VBA.

Any help is appreciated.

Frank

Wow, thanks for the quick reply!

So I took too long working on my reply and the forum logged me out. Dangit.

The IF and ISBLANK got me the names, and I scrounged around looking for a way to get rid of the blanks. F5/Custom.../Blanks/Ctrl- didn't work (maybe because of XL2007?), so I hit the internet to see what else I could find.

Suffice it to say I got a macro from http://www.mvps.org/dmcritchie/excel/delempty.htm, and tweaked it a little so it would count a formula with a null result as though it were a blank cell. While that makes it sound like I knew what I was doing, I really just fiddled with stuff until it did what I wanted. I really don't understand what half of the lines in this macro are doing, I'm afraid.

Sub DelCellsUp()
Application.Calculation = xlCalculationManual
Dim rng As Range, ix As Long
Set rng = [A3:CQ133]
For ix = rng.Count To 1 Step -1
If Len(Trim(Replace(rng.Item(ix).Text, Chr(160), ""))) _
= 0 Then rng.Item(ix).Delete (xlUp)
Next
done:
Application.Calculation = xlCalculationAutomatic
End Sub

It works, but it's slow, taking several minutes to process the 12,000 or so cells in the current version of the sheet. Is this an inefficient way to do it, or do I just need a new faster computer?