Try this:
Make a list of the Job Titles you are interested in flagging and name that
range:
Example:
D1: Supervisor
D2: Skilled
D3: Unskilled
D4: ThisJob
D5: ThatJob
D6: SomeJob
Name the range something like 'LU_JobTitle'.
Then, assuming the column of titles begin in cell A2) and you want the flags
in Col B, put this formula in B2 and copy down :
=IF(COUNTIF(LU_JobTitle,A2),"X","")
Or without the range name:
=IF(COUNTIF($D$1:$D$6,A2),"X","")
Does that help?
Ron
"timbo" wrote in message
...
I have 3 classifications of workers(supervisors,skilled, and unskilled) and
need to post a x in a cell by their jop title. I have been using the IF
funtion for years, but only had 5 or 6 job titles. Now with more job
titles,
I have surpassed the maximum of 7 nest funtions.
|