=IF([Your criteria for A],"A",IF([Your criteria for B],"B",IF([Your
criteria for C],"C",IF([Your criteria for D],"D","FALSE"))))

[Your criteria for A] would be whatever you are using to break the data
into
different categories (e.g. A11000)

Is this what you are looking for?


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510165