solved: used maxifs and wildcards: "*"&cell&"*"
simples in the end
simples in the end
Excel seperate data into a Matrix
Im looking to transform data output into a matrix.
The data - continous table:
Date Names Topics
1/1/01 Tom;Dick;Harry topic1;topic2;topic3
7/1/01 Dick;Harry topic1;topic4
The matrix required:
Topic1 Topic2 Topic3
Tom date date date
Dick date date date
Harry date date date
the dates to appear in the matrix are the latest dates of occurence of that topic for that person
there can be more than 20 names and topics
how would you solve this riddle? thanks for looking
The data - continous table:
Date Names Topics
1/1/01 Tom;Dick;Harry topic1;topic2;topic3
7/1/01 Dick;Harry topic1;topic4
The matrix required:
Topic1 Topic2 Topic3
Tom date date date
Dick date date date
Harry date date date
the dates to appear in the matrix are the latest dates of occurence of that topic for that person
there can be more than 20 names and topics
how would you solve this riddle? thanks for looking
