V
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
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