I have a set of data (A1:H658). In column A, I want to put an "X" next to any rows that I want to pull over.
My traditional way of doing this is to do an IF statement that says IF(A1="X",B1,""). But this returns a lot of blanks. For example, if I have ~500 rows of data, and I put an "X" next to 200 rows, then I have 300 rows of blank data. I would traditionally highlight this list, and filter out the blanks.
There has to be a better way of only returning rows of data (from column B to H) to another worksheet, if there is an X in column A.
Here are my headers and columns:
<tbody>
</tbody>
Does that make sense?
Thanks so much! I will forever being using this formulas, as I do a lot of this! Thanks!
My traditional way of doing this is to do an IF statement that says IF(A1="X",B1,""). But this returns a lot of blanks. For example, if I have ~500 rows of data, and I put an "X" next to 200 rows, then I have 300 rows of blank data. I would traditionally highlight this list, and filter out the blanks.
There has to be a better way of only returning rows of data (from column B to H) to another worksheet, if there is an X in column A.
Here are my headers and columns:
A | B | C | D | E | F | G | H |
Include in Assessment? | Ref # | SC, OF, or SCOF | Excellence Category | Function | Sub-Function | Process | Description |
X | 1 | SC | People | Purchase | Buyer | HR | BLAH BLAH BLAH |
<tbody>
</tbody>
Does that make sense?
Thanks so much! I will forever being using this formulas, as I do a lot of this! Thanks!