清空筛选条件
清空筛选条件

Rearranging assigned data in a required order

1 次查看（过去 30 天）
JAGAN MOHAN KUMMARI
评论： Stephen23 2018-9-15
Hi,
I want to read an excel file of two columns. Column A is assigned with values in Column B.
Ex:
Col A 1 2 3 4 5 6 7 8 9 10
Col B 10 8 5 25 31 12 29 1 21 44
How can I get the output of Column B reassigned to any specific order of Column A
Ex: o/p for the following order of
Col A 2 6 8 4 9 3 1 5 7 10
as
Col B 8 12 1 25 21 5 10 31 29 44
Thank you.

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2018-8-29
编辑：Stephen23 2018-8-29

更多回答（1 个）

JAGAN MOHAN KUMMARI
Thanks, Stephen!
Got it.
a=xlsread('values.xls');
b=a(:,2)
c=a(:,3) % col c is the required order from a
b([c]) % gives the answer
Thanks.
  6 个评论
显示 4更早的评论
JAGAN MOHAN KUMMARI
JAGAN MOHAN KUMMARI 2018-9-15
True. Got it. I need more learning. Getting familiar with things.
Thanks mate!
Stephen23
Stephen23 2018-9-15
@JAGAN MOHAN KUMMARI: check out the link in my answer.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by