In G4:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/($C$1:$C$13="Production"),ROWS($1:1))),"")
In H4:...
Sample attached. Thank you!...
How are these things related?
Attach a small sample workbook illustrating what you want to achieve....
Hi all,
I have a table located on one worksheet that contains some columns & rows that I want to pull into a second table.
...
Conditionally filling a table based on non-unique information from another table
By the way. xlsm is NOT a version of Excel! This should be something like 2019 or 365 - please update your forum profile. Thanks....
AliGW Today, 02:21 PM