Thread: Putting columns back in alpha order
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
  
Posts: 156
Default Putting columns back in alpha order
Try using

=AVERAGE(A1:G1,AU1)

Sandy


CLytle wrote:
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

Reply With QuoteReply With Quote