cell containg comma separated value in excel

8 vues (au cours des 30 derniers jours)
vikas
vikas le 9 Mar 2017
Modifié(e) : KSSV le 9 Mar 2017
i am working on excel having cells containing comma separated values like A1=1,2,3,4,5,6 and B1=3,4,5,6,7,9. i have to perform union , intersection operation on these cells. plz help me thanks and regards

Connectez-vous pour répondre à cette question.

Réponses (1)

KSSV
KSSV le 9 Mar 2017
Read about xlsread, csvread, union, intersection. Your problem is pretty easy and straight forward.
  3 commentaires
Afficher 1 commentaire plus ancien
KSSV
KSSV le 9 Mar 2017
You can arrange them, into one cell after you get. Attach the file and your code.
vikas
vikas le 9 Mar 2017
Modifié(e) : KSSV le 9 Mar 2017
thanks for the reply
% i imported tha data directly to workspace as textdata
%data of first lecture
I=textdata(:,2);
II= txtdata(:,3); % data of second lecture
% now performing the union for cell (9,8) in excel fine by coding)
f1=fopen('record.xls')
textdata{9,8}= union(I,II);
% after this everything went wrong and even dont get the idea to save union
% operation in excel directly

Connectez-vous pour commenter.

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by