I cant sort it becuase when i sort then the data is no longer in order
EX.
A1=ME B1=you C1=they if i sort the 3 columns then me you they will no
longer be parallel to each other. It would be something like A1=Me
B1=Me C1=ME.

Also the formulas are unusable becuase as it was already said if i put
the formulas into the all 14k a rows then it will delete all my data in
the A column same goes for the C column.


--
flyingby
------------------------------------------------------------------------
flyingby's Profile: http://www.excelforum.com/member.php...o&userid=27844
View this thread: http://www.excelforum.com/showthread...hreadid=473523