Hi Graham,
I experimented a little and found the following solution for you:
In added 2 columns before the one with the heading C/M.
In col G I put the following formula:
=IFNA(VLOOKUP($G$13,INDIRECT(B(14+E13):C$40), 2, 0),)
In col E I put:
=MATCH(G14,INDIRECT($C14+E13):$C$39,0)+E13
To get
If i have a list over a number of columns how would i create a new list of
only certain rows from that list
Yes i know thats as clear as mud so i've attached a example spreadsheet
The column starting at B14 has membership type with (C14) a name next to it
- the actual sheet has more data.
Each
At 07:37 24/03/2015 -0700, Graham Lovatt wrote:
If i have a list over a number of columns how would i create a new
list of only certain rows from that list
If you want to do this dynamically, so that the sub-list updates
automatically from the main list (as is suggested by your mentioning