I am trying to get the value from a specific cell from a large range of data. The only criteria i have is the day, so basically i need to find the highest value in a specific column that has a specified day to it (day in column A for example).
But the value i need must meet the criteria if another column contains data.
That probably doesn't make much sense so here is my example:
Say for example I have 4 columns with large amounts of data covering a time period as you can see from the below example;
example.jpg
Now what i would like to do is get the value for the highest in the 'values' column where the day = 01 but only if the country column has a value.
Basically my goal is to grab the top ten highest values where the country column is not empty and place those values in another range of cells listing the top ten values from each country. then of course i will need to pull those country values to another range of cells to display those countries with their respective values.
I hope i am making sense with all this, please forgive me if i am not. The actual sheet i am pulling this from will be from a DB with thousands of rows all with various data. This is the bit where i am getting stuck. If any one could help me out with this i would be very grateful. Cheers
Bookmarks