Hi! I have this data:
I would like to find a formula that can move the data in the right column, which is in the order A01, A03, A05 etc into the left column, which is in a different order. In other words, it will rearrange the data to fit the new order of the left column. Is this possible?
Thank you!
Last edited by loobim; 11-22-2012 at 07:54 PM.
why an image?
"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
Is that not good? Sorry, I'm new here ...
if you add an excel file without confidentional information, we are able to test the solution.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks