# Extracted names from list if value greater than 2

1. ## 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

Majort

2. ## Re: Extracted names from list if value greater than 2

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

3. ## Re: Extracted names from list if value greater than 2

Fuel Check updated sample.xls

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

Thanks

4. ## Re: Extracted names from list if value greater than 2

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

5. ## Re: Extracted names from list if value greater than 2

Sorry Fell Asleep, Its late here.

Thanks You Very Much

Thats Brilliant

6. ## Re: Extracted names from list if value greater than 2

You are welcome. Thanks for the feedback.

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

New quick method:

Or you can use this way:

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

There are currently 1 users browsing this thread. (0 members and 1 guests)