3 condition lookup (or index&match)

Hi, can someone help me with this problem i have.

On a source table i have something like this:

 

m1 m2 m3
a 31-Dec 39 75 64
a 10-Jan 28 48 87
a 20-Jan 71 26 27
a 31-Jan 38 3 35
b 31-Dec 25 65 49
b 10-Jan 73 27 93
b 20-Jan 42 1 80
b 31-Jan 41 67 41
c 31-Dec 70 41 37
c 10-Jan 62 83 10
c 20-Jan 6 64 76
c 31-Jan 70 91 14

 

then i want to summarize it into this:

 

31-Dec 31-Dec 31-Dec 10-Jan 10-Jan 10-Jan
m1 m2 m3 m1 m2 m3
a
b
c

What formula can i use to fill the blanks?

 

By: Erick

Leave a Reply

Your email address will not be published. Required fields are marked *