Return Row based on value in column

[vdog16]

Hi everyone,

I have a master worksheet with all of my data... about 200 rows worth
of items and 10 columns of information about each item.

I am trying to write a formula that returns an entire row of
information based on the value in a column.

For instance, if I have a column labeled "Category", I want that entire
row of information to be returned if category = "A". If it does not
equal "A", then it should do nothing. It will then look at the next
row, and the next, and apply the same condition. The goal is to have
various worksheets broken out by "Category" with only the rows of
information that fall into that "Category".

Furthermore, if only row 7 and row 50 out of 200 rows meet the "A"
criteria, I want those two rows to be displayed on the top two rows of
the "A" worksheet, not at position 7 and position 50.

Basically, it is equivalent to using the filter function, only I have
just one "master" worksheet of data that each of these other worksheets
are linked to through these formulas I am trying to write.

I have the feeling that this may be a simple solution, but I am under a
deadline and thought someone here may be able to help. Please let me
know if you need any more information.

Thanks in advance!

Victor

 

[vdog16]

please help!

 

[Ron Coderre]

Since I have concerns that a formulaic approach might result in a
overly bloated workbook, I'll recommend this Advanced Filte
technique:

http://www.contextures.com/xladvfilter01.html#ExtractWs

Your thoughts?

Regards,
Ro

 

[Pete_UK]

Check out the VLOOKUP( ) function in Excel Help - this should be able
to do what you ask with a bit of adjustment.

Hope this helps.

Pete

 

[vdog16]

thanks for both of your help... i actually ended up using pivot table
which did the job. great tips!!