I confess I'm struggling to visualise exactly...
You would potentially get a #VALUE! error with the MIN formula if you did not confirm as an Array (ie see text in red) - ie you must use CTRL + SHIFT + ENTER ... that said have you created a Named range for Column E also ?
Here would be my suggestion... without knowing remaining particulars of your file...
If we assume that Project column is never empty when the row is in use (ie no interspersed blanks - as implied by your earlier use of COUNTA) then:
You can then either
a) create a Pivot Table and use _DATA as reference (create accordingly)
(assumes you have header values in row 1 on Value sheet in Columns B:E)
b) use the earlier array but adapt per the above name range, eg:
becomes
In the above you will note I used INDEX & MATCH to create the Dynamic Name rather than OFFSET - this is purely because OFFSET is Volatile and INDEX is not thus I prefer the INDEX approach (it's a personal thing)
Re: use of REPT("Z",255) - this is technique for finding last values of a given data type (I've assumed Project Names are always text strings (ie never numbers)) - for a guide on "finding last value" techniques see Bob Phillips' white paper: http://www.xldynamic.com/source/xld.LastValue.html
If you're still struggling it might be an idea to post a non-confidential version of your file so we can see what you're using exactly.
Bookmarks