Maybe something like this.

This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Drag formula down rows as needed.

A B S T U AP AQ 1 Name Amount Company 2 Emp1 200 Com1 3 Emp2 1100 Com2 4 Emp3 565 Com3 5 Emp4 3000 Com4 6 Emp5 250 Com5 7 Emp6 2500 Com2 8 Emp7 125 Com7 9 Emp8 98 Com8 10 11 12 Find Com2 13 Names Emp2 14 Emp6 15

Spreadsheet Formulas

Cell Formula B13 {=IFERROR(INDEX($A$2:$A$9,SMALL(IF($AQ$2:$AQ$9=$B$12,IF($T$2:$T$9>1000,ROW($A$2:$A$9)-ROW($A$2)+1)),ROWS($B$13:B13))),"")} Formula Array:

Produce enclosing { } by entering

formula with CTRL+SHIFT+ENTER!

Excel tables to the web >> Excel Jeanie HTML 4

## Like this thread? Share it with others