Sorting names in Name box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have crated names (in the name box on the formula bar) for several ranges
within a work sheet in exel, 52 names each representing a week number e.g.
week1 week2 etc. How can i sort the list so it starts with week 1 throught to
week 52? I've tried alsorts.. any help would be appreciated.
 
Many thanks.. yes it woorks.. tho' i have used week__1 week__2 etc. then
week_10 week_11 etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Limit to Named Ranges 1
Adding up values from separate tabs 2
Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
WEEKNUM to dynamic range name 5
List cumulative values in a column 1
Content of cell in Vlookup function 1
Group information from several worksheets into one worksheet 1
array formula to show differences in 2 lists? 1

Back
Top