Using Functions to Extract a list within a bigger list

[crazy415]

I have a Master List of 2000 items in a specific order.

I often need need to access a part of the list.

Is there an easy function or combination of functions that would allow
me to:

Create smaller lists of varying lengths by identifying the first item
in the Master List and stating how many items below it I would also
like displayed?

Thanks so much.

Dano

 

[Bernard Liengme]

The list is in column A
The required stating item is in C1
The required number of items is in D1
In E1 enter =IF(ROW()<=$D$1,INDEX(A:A,MATCH($C$1,A:A)+ROW()-1),"")
Copy this down the column - if your max number in D1 in N, then copy down to
row N
If you want the list to start in some other row, alter the value 1 to match
start row
best wishes