confused;432135 Wrote:
I forgot to specify that I need to look up the minimum, maximum and
average for each name and year, so the "Data" sheet shows 14 results but
since I am looking for the minimum, maximum and average for each name
and year, it is 33. The reason why 2009 is not populated is because if
you filter the "Data" tab, by A1, and date, the column D "year" does not
show 2009. I populated manually the table in the "Amt by Year" tab.You're not going to manage what you want with formulae, it's going to
have to be VBA, i won't have time to look at that right now, i will have
a look tomorrow though.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295