use function unique and find in two different sheets of xls

1 次查看（过去 30 天）
Nooshin Mahmoodi
Nooshin Mahmoodi 2018-11-4
评论： dpb 2018-11-4
My data is more than one sheets of excel(the number of rows are more than one sheet), but I need to find the unique value in one column.is it possible to write code in way that function unique works in way that thinks two sheets are continues each other?

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

采纳的回答

dpb
dpb 2018-11-4
Not directly, no.
Read both sheets; concatenate the two and call unique on the result, or
Read first sheet, call unique on that portion; rinse repeat for second then return intersection of the two results.
  6 个评论
显示 4更早的评论
Nooshin Mahmoodi
Nooshin Mahmoodi 2018-11-4
my data are the same in the vertically (columns). sorry, but what is the stream? I never use it
dpb
dpb 2018-11-4
Simply the "stream" of bytes written/read to/from disk w/o the overhead of character translation/formatting. Often called "binary". Use fopen/close, fread/write and friends in Matlab.
Where are all these data coming from and how are they getting into Excel? There would be the place to start removing bottlenecks and making savings/increasing efficiency.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by