Hi Team,
I have below data, Player Name in Column A and their total Scores Every Year.
and Criteria List is in Column F. as per Criteria List it has to show output in Column H & I.
I am looking for answer in collection or Dictionary you can take help of class module if needed. I am trying to learn collection/dictionary how to use it in below Scenario.
I have below data, Player Name in Column A and their total Scores Every Year.
and Criteria List is in Column F. as per Criteria List it has to show output in Column H & I.
I am looking for answer in collection or Dictionary you can take help of class module if needed. I am trying to learn collection/dictionary how to use it in below Scenario.
Name | 2017 | 2018 | 2019 | Criteria List | Expected Output | |||
Sachin Tendulkar | 1000 | 700 | 1500 | Sachin Tendulkar | Player Name | Total Scores | ||
Rohit Sharma | 800 | 500 | 1400 | Dhoni | Sachin Tendulkar | 3200 | ||
Virat Kohli | 900 | 600 | 1600 | Ricky Ponting | Dhoni | 3000 | ||
Jason Roy | 700 | 1400 | 500 | Davin Warner | Ricky Ponting | 2500 | ||
Buttler | 400 | 900 | 1100 | Jaysurya | Davin Warner | 4000 | ||
Jaysurya | 800 | 600 | 400 | Buttler | Jaysurya | 1800 | ||
Ricky Ponting | 1200 | 900 | 400 | Buttler | 2400 | |||
Dhoni | 500 | 1500 | 1000 | |||||
Davin Warner | 2000 | 1500 | 500 |