View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Help With Sorting

Perhaps you could relabel your racks to identify tiers...

01A-1 bin1, level1
01A-2 bin2, level1
01B-1 bin1, level2
01B-2 bin2, level2
01C-1 bin1, level3
01C-2 bin2, level3

Optionally, you possibly don't need the hyphen at all...

01A1 bin1, level1
01A2 bin2, level1
01B1 bin1, level2
01B2 bin2, level2
01C1 bin1, level3
01C2 bin2, level3

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion