title: Excel , how to find highest column value for a given value from another column
body: <p><strong>country           Initiative 1    Initiative 2    Initiative n    Week</strong> </p>
  
  <p>Country 1               Status 1    Status 1    Status 1         1</p>
  
  <p>Country 2       Status 2    Status 2    Status 2         1</p>
  
  <p>Country 1               Status 3        Status 2        Status 1         2</p>
  
  <p>Country 2               Status 3        Status 2        Status 2         2</p>
  
  <p>I have an excel file where I collect initiative statuses per country , they are collected per week ( to have a history of initiative evaluation )
  I want to build a pivot chart to display the current initiative status by country, but in this table structure ( i cannot change the structure only do modifications in excel ) i cannot do this ( or i don't know how) as initiates are used as headers .</p>
  
  <p>So i wanted to kind of transpose the table into this structure:</p>
  
  <p>Initiative          Status        Country      Week</p>
  
  <p>Initiative 1       Status1        Country1      1</p>
  
  <p>Initiative 1       Status2        Country2      2</p>
  
  <p>Is it somehow possible - i think that transpose excel function will not do what i want.</p>
  
  <p>I wanted to list all initiatives in initiative column and then in column status display the highest status for each country</p>
  
  <p>So i need a function to look into Initiative column and get the highest status for a given country.</p>
  
  <p>Any help appreciated </p>