Using Functions to Extract a list within a bigger list

  • Thread starter Thread starter crazy415
  • Start date Start date
C

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
 
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
 
Back
Top