davidmckee
Technical User
Good evening hoping someone can help. Looking for a formula which will identify the most frequent text value based on a lookup. The example I have all date for June with 4 different times and conditions. I want to get the most frequent description for that day with the date being a variable so on the summary tab I can enter a date and it will look to this data tab and that date and find the right description. So if on the summary page I said report on 06/02/10 if would bring back the result *Sunny*
Column A Column B Column C
06/01/10 6am Cloudy
06/01/10 1pm Sunny
06/01/10 5pm Cloudy
06/01/10 10pm Rainy
06/02/10 6am Cloudy
06/02/10 1pm Sunny
06/02/10 5pm Sunny
06/02/10 10pm Rainy
Column A Column B Column C
06/01/10 6am Cloudy
06/01/10 1pm Sunny
06/01/10 5pm Cloudy
06/01/10 10pm Rainy
06/02/10 6am Cloudy
06/02/10 1pm Sunny
06/02/10 5pm Sunny
06/02/10 10pm Rainy