Ageing number cruncher!
Hi,
I have a 2 ranges of data that are used to calculate a number using the following formula:
=SUM(COUNTIFS('Open Fields'!C2:C220,{"*Apples*"},'Open Fields'!G2:G220,{"North West"}))
This tells me how many "Apples" are attributed to the "North West". Each apple has an age (number of days old) associated with it in another column range F2:F250. I wish to identify the oldest "apple" but cannot get any formula to work, i.e. using "MAX".
Your help would be much appreciated!
Bookmarks