Thank you very much. Appreciated. i would also like to use a formula for the same. I am using Microsoft Excel 2016. Kindly could you assist with the proposed formula?Would it be feasible to do this with a pivot table?
In the attached, select your Unit and Project in cells I1:I2 and your names will appear from cell H5 down.
For a formula: Which version of Excel do you use (will it handle worksheet functions such as Filter and Unique)?
Thank you very much, i will try get an updated version of Excel to use the UNIQUE and FILTER functions. Much Appreciated.See cell B10 in the attached.
If your version of Excel supports UNIQUE and FILTER there's a formula D10 as a cross check, as well as the pivot also being a cross-check.
Wooow, Great. Thank you sooo much!!! This works perfectly. Much Appreciated Excel Ninja. Thanks.Since the OP's Excel version is Excel 2016, of which do not have UNIQUE and FILTER functions.
Here is the formula solution for Excel 2019 or below.
Changed your formulas in the following position :
1] Sheet "Index" H7, formula copied down :
=IFERROR(INDEX('Transaction listings'!F:F,AGGREGATE(15,6,ROW('Transaction listings'!F$2:F$18)/('Transaction listings'!C$2:C$18=E$5)/(COUNTIF(H$6:H6,'Transaction listings'!F$2:F$18)=0),1)),"")
2] Sheet "View" B10, formula copied down :
=IFERROR(INDEX('Transaction listings'!A:A,AGGREGATE(15,6,ROW('Transaction listings'!A$2:A$18)/('Transaction listings'!C$2:C$18=Index!E$5)/('Transaction listings'!F$2:F$18=Index!H$5)/(COUNTIF(B$9:B9,'Transaction listings'!A$2:A$18)=0),1)),"")
View attachment 76107