If and & formulas - excel 2003

[Aeroney]

Ok, I have worked out some of this so now my question will be more specific.

On the attached sheet the data in black is how my report currently looks. As you can see each user's Certs are listed in rows. What I want to do is put that same data into coloums along side the current report.

As I have up to 900 Ppl on my report, it would make life much easier to be able to get everyone on one line of data as opposed to 5,6 or even 7 rows per person.

I was thinking that the formula would read like this:

If D3 = "Making bag" and G3 is not blank then put "yes", if G3 is blank put "no.

Of course then I want to be able to delete the extra rows so this would be a 2 part process. I have around 6 of these reports to do with around 200 to 950 people on each report, so the quickest and easiest way would be great, keeping in mind that this report will be sent to external groups who are not familiar with things like pivot tables, which was one of my other options, or drop down boxes.

Hope this makes better sense then my last post

Kind regards
Aeroney

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.