Hello,



I have a data file that displays the person name and the amount of activity as a total at the end of the column.

I want to create a cover page that would display any name that has activity greater than 3. What formula would I use for that?

Thank you,
see attached worksheet

Attached Files

Book1.xlsx (8.9 KB, 7 views)

On tab total in A3...

=IFERROR(INDEX(Sheet1!$A$2:$A$38,SMALL(IF(Sheet1!$ H$2:$H$38>3,ROW(Sheet1!$A$2:$A$38)-ROW(Sheet1!$A$2)+1),ROWS($A$2:A2))),"")

IMPORTANT

• This is an array formula
• Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
• If entered correctly, the formula will be enclosed in {brackets}
• Do not enter the {brackets} manually

On tab total in B3...

=IF(A3<>"",VLOOKUP(A3,Sheet1!$A$2:$H$4,8,0),"")

Highlight A3:B3 and drag down as you need

Thank you. It worked great.