use function unique and find in two different sheets of xls
1 次查看(过去 30 天)
显示 更早的评论
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?
0 个评论
采纳的回答
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 个评论
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 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!