How may I retrieve data from an Excel table based on a variable number of criteria?
- by Eshwar
I have the following salary data for example:
Country State 2012 2013 -> 2027
======= ===== ==== ====
China Other 1000 1100
China Shanghai 1310 1400
China Tianjin 1450 1500
India Orissa 1500 1600
So now in another Excel sheet I would want an answer to one of the following questions:
What is the salary…