Here's my offer for you, Leslie

Illustrated in this implemented sample:
http://freefilehosting.net/download/434b8
Automated Competency Assmt-Devt Plan.xls

(Remember to press the YES button below, won't you?)

In sheet: Individual Development Plan,
First, remove all merged cells in rows 13 down

In an adjacent area to the right (say in cols BB to BE which will be hidden
away)
Hardwire it with simple link formulas pointing to the various "In Part, No"
cells in "Leadership Talent Assessment" within BB13:BC21
eg, for Accountability, in BB13:BC13
='Leadership Talent Assessment'!AD26
='Leadership Talent Assessment'!AD28
and so on, for all 9 competency attributes

Then place in BD13: =IF(COUNTIF(BB13:BC13,"x"),ROWS($1:1),"")
Copy down to BD21

List the 9 corresponding competency attributes in BE13:BE21, ie:
Accountability
Business Acumen
Communication
Customer Focus
Decision Making
Leadership
Results Orientation
Teamwork
Core Values

Then place in A13:
=IF(ROWS($1:1)COUNT(BD$13:BD$21),"",INDEX(BE$13:B E$21,SMALL(BD$13:BD$21,ROWS($1:1))))
Copy down to A21. This will return the exact automated results that is
sought, with all competencies requiring development neatly bunched at the
top. Then add a nice simple dash of CF which is pegged to the possible
returns in A13:A21. Select A13:AZ21, apply a normal fill of gray. Then select
A13:AZ21 (with A13 active), apply CF using Formula Is: =$A13<"". Format it
with white fill Ok out.

Test it out. It'll function exactly as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Leslie" wrote:
Thank you for your assistance, Max. Here's the link to my file.
http://freefilehosting.net/download/433hm