I may be using the incorrect word in "sort". What I would like to do is
have column B search column A for a particular letter or word and enter
it in straight order, B1, B2, B3, so on, not B1, B5, B15, and so on. I
do not want B1=a, B2=blank, B3=blank, B4=blank, B5=a, and so on. I
tried different variations of formulas, but can't get any of them to
work correctly.


--
johnrhyme1
------------------------------------------------------------------------
johnrhyme1's Profile: http://www.excelforum.com/member.php...o&userid=37828
View this thread: http://www.excelforum.com/showthread...hreadid=573822