Extracting Data

[claire_pike]

Hi,

In a spreadsheet I have a column of week numbers and a column of codes that look like CLBER etc, but what I'd like to do is do a search on a week number and bring back all the codes with those week numbers.

Is this possible?

Thanks,

Claire

 

[Oaktree]

Claire:

Have a look at data --> filter --> autofilter. Once you apply the filter, you can easily filter your data for the appropriate week number.

 

[HalfAce]

Hello Claire,
Is there a reason that filtering the sheet on the week number of interest won't
work for you or is there more to what you're doing than what's posted?

 

[claire_pike]

Data

Unfortunately this isn't good enough, I need it to bring back a list of codes per week number! Sorry.

 

[Oaktree]

If filtering isn't what you had in mind, have you considered a pivot table?

 

[xcellnoob]

Wouldn't VLOOKUP be useful here?