Max,
It was exactly what I was looking for!
Other question on the rows that are coppied over to Liahona the first 4
boxes are Names and right now it only puts 2 letters in the cells on Liahona
I´m wondering if theres a way to make it bigger? so I can see the names?

"Max" wrote:

Perhaps something along these lines ..

In sheet: week #1
------------------

Let's use an empty col to the right, say col AP

Put in AP5: =IF(AN5="","",IF(AN514,ROW(),""))

Copy AP5 down to say, AP1000
to cover the max expected data range in cols A to AN
(can copy down ahead of data input in cols A to AN)

In sheet: Lianhona #1
------------------

Put in say, A2:

=IF(ISERROR(SMALL('week #1'!$AP:$AP,ROWS($A$1:A1))),"",INDEX('week
#1'!A:A,MATCH(SMALL('week #1'!$AP:$AP,ROWS($A$1:A1)),'week #1'!$AP:$AP,0)))

Copy across to AN2, fill down to AN1000
(cover the same range as in "week #1")

The above will return all the rows from "week #1" (cols A to AN)
for which the values in col AN in "week #1" exceeds 14

And it'll achieve this w/o any intervening blank rows
(all blank: "" rows will be thrown below the last row of data returned)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom