Extracted names from list if value greater than 2

Hi Guys

I have created a spreadsheet which has a 100 names in coloumn B, then Numerical Data from D-J With the Total in Coloumn K. (In Worksheet 2)


On Worksheet 1 I have created a summary page.

In Cell A I have the following formula: (Counting how many cells in Coloum K are greater than 2)

=COUNTIF(Worksheet2!K3:K100,">2")

For example if there was 4 out of 100 greater than 2 could I list there names under cell A in worksheet 1 from the data in Coloumn B worksheet 2, like below:


Greater than 2
4
Mike
John
Steve
Carlos


Any Help would be much appreciated

Thanks in Advance
Majort

Hi Majort,

In cell A1 on Sheet1

=COUNTIF(Sheet2!$K$2:$K$13,">2")

Then in Cell A2 on Sheet1

=IF(ROWS($A$2:A2)<=A$1,INDEX(Sheet2!$B$2:$B$13,MATCH(0,IF(Sheet2!$K$2:$K$13>2,COUNTIF($A$1:A1,Sheet2!$B$2:$B$13)),0)),"")

Expand the range to fit your data and then drag down until you get blanks

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

Fuel Check updated sample.xls

I am trying to add the names in the cells below B9 from the summary tab.

Thanks

Sorry, took a few extra minutes until I figured out you had two Tinkler's so I combined the names in a helper column.

You are welcome. Thanks for the feedback.

===========================================================================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save