Hi Steve,
Am Wed, 15 Apr 2015 13:44:38 +0100 schrieb SteveRH:
This has thrown up one further issue though, being that if there are 2
or 3 milestones in the same week I am currently only able to show the
first one. I know I can paste your formula into an array of cells to
obtain multiple results but that seems only to work if the results array
is a vertical one. I could really do with returning the multiple
results horizontally in columns G, H and I. Is there a genius solution
to this?
list all occurances of your weeks in column F.
Then try in G2:
=IFERROR(INDEX($B$1:$B$100,SMALL(IF(($A$1:$A$100=" Milestone")*($C$1:$C$100=F2),ROW($1:$100)),COUNTIF ($F$2:F2,F2))),"")
insert the array formula with CTRL+Shift+Enter and copy down.
Or look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for workbook "INDEX"
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional