selecting by week number??????

M

Mike

In a\league schedule i have 18 different weeks of fixtures, is it possible to
select a weeks fixtures on a diiferent sheet by using week numbers, e.g if i
put week1 in a cell the fixtures for that week will be displayed
 
M

Mike

I just need to select some data on one sheet and transfer it to another by
using a number relative to our league weeks.
 
B

Bob Phillips

Assuming that the week number is in column A and fixtures in column B of
Sheet1 the, select a range of cells on sheet2 for the maximum number of
fixtures, and in the formula bar enter

=IF(ISERROR(SMALL(IF(Sheet1!$A1:$A200=1,ROW($A1:$A20),""),ROW($A1:$A20))),""
,
INDEX(Sheet1!$B$1:$B$200,SMALL(IF(Sheet1!$A1:$A200=1,ROW($A1:$A20),""),ROW($
A1:$A20))))

as an array, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top