use function unique and find in two different sheets of xls
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Nooshin Mahmoodi
el 4 de Nov. de 2018
Comentada: dpb
el 4 de Nov. de 2018
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 comentarios
Respuesta aceptada
dpb
el 4 de Nov. de 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 comentarios
dpb
el 4 de Nov. de 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.
Más respuestas (0)
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!