View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Formula to sort text and return reference value

I was able to get the first request to work. Still having trouble with the
"ABCD" format though. I want it sorted as a repeating series. For example,
A, B, C, D, A, B, C, D, ...