use function unique and find in two different sheets of xls
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
dpb
on 4 Nov 2018
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 Comments
dpb
on 4 Nov 2018
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.
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!