Tech Support Guy banner

Excel seperate data into a Matrix

1205 Views 1 Reply 1 Participant Last post by  crashdown
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 :)
Not open for further replies.
1 - 2 of 2 Posts
solved: used maxifs and wildcards: "*"&cell&"*"

simples in the end
1 - 2 of 2 Posts
Not open for further replies.