Extracting from a list

[jho78]

Hi


I am having a problem and was wondering if there is a formula that could help.


I have a workbook containing 3 columns A(group), B(first name), C(surname)with people in surname alphabetical order. I am trying to extract a list on to another worksheet only those people from group 1 in a continuous list. Is that possible without sorting the data?


Thanks


Jeff

 

[Hui]

Jho78


Firstly, Welcome to the Chandoo.org forums


You might want to have a read of the technique Luke has described here which will do what you want:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[jho78]

Thanks Hui


Thats sorted my problem.


Thanks.