How to rearrange the order of fields in Excel/spreadsheet?
For example, the order I currently have:
Name:
Phone:
Email:
Address:
Fax:
Website:
But I want:
Name:
Address:
Phone:
Fax:
Email:
Website:
The problem is there are MANY entries in that order, and I CANNOT manually drag rows one by one.
Please check the attachement
slighly less involved
with list in column a starting a1 in col b numberthe first lot
in the order you want
then in b7 put =a1+6 and drag down to end of listName: 1
Phone: 3
Email: 5
Address: 2
Fax: 4
Website: 6
sort by col b
Last edited by martindwilson; 03-27-2011 at 08:26 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks