Thread: Column sort
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
duane[_7_] duane[_7_] is offline
external usenet poster
 
Posts: 1
Default Column sort

not sure if this wil help, but if you can, sort (ascending) and add to
two rows. if you can't sort, build separate database referrenced t
the original like =$a$1 for cell a1, and =$a$2 for cell a2, etc an
then do the sort on this list - this could be place on a separate shee
if need be. the idea is to creat e the list sorted low to high (in
known position) so you can just add two cells

--
Message posted from http://www.ExcelForum.com