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
Bookmarks