influentialgenius
New Member
- Joined
- Mar 27, 2014
- Messages
- 1
Hello all,
This is my first post on here, familiar with some aspects of Excel but need some help with this please if anyone can help!
I have a worksheet in excel that contains values from two other worksheets and compiles all the data into one large list. The list if you imagine contains Names of people in column A, the persons age in B, address in C, etc. In Column H there would be an X in the box (input automatically dependant on other values in the table). On a forth (currently blank) worksheet, I want to put a formula that 'grabs' the rows that contain an X in Column H, getting rid of all the rows in between. I want this to work automatically so if the initial data is changed, this sheet then updates.
As an idea on the table, it would look something similar to this:
NAME / AGE / ADDRESS / ??? / ??? / ??? / ??? / AVAILABLE / NOT AVAILABLE
Jenny / 24 / ???????? / ??? / ??? / ??? / ??? / X /
Mark / 23 / ???????? / ??? / ??? / ??? / ??? / / X
Shawn / 28 / ???????? / ??? / ??? / ??? / ??? / / X
Lee / 33 / ???????? / ??? / ??? / ??? / ??? / X /
James / 38 / ???????? / ??? / ??? / ??? / ??? / X /
The new worksheet would see that there is an X in the Available box and input the rest of the row, but all the data would have no empty rows. (I do not want anything for the 'Not Available' section as there will be 3 or 4 different options so if there is a way of doing it, I will use a similar formula for each option.
NAME / AGE / ADDRESS / ??? / ??? / ??? / ??? /
Jenny / 24 / ???????? / ??? / ??? / ??? / ??? /
Lee / 33 / ???????? / ??? / ??? / ??? / ??? /
James / 38 / ???????? / ??? / ??? / ??? / ??? /
If that makes sense to anyone and you are able to help, please come back to me!
I am not great with the more techy formulas so if it is a very long one, I would appreciate if you could explain a little about how to input it.
Many Thanks
This is my first post on here, familiar with some aspects of Excel but need some help with this please if anyone can help!
I have a worksheet in excel that contains values from two other worksheets and compiles all the data into one large list. The list if you imagine contains Names of people in column A, the persons age in B, address in C, etc. In Column H there would be an X in the box (input automatically dependant on other values in the table). On a forth (currently blank) worksheet, I want to put a formula that 'grabs' the rows that contain an X in Column H, getting rid of all the rows in between. I want this to work automatically so if the initial data is changed, this sheet then updates.
As an idea on the table, it would look something similar to this:
NAME / AGE / ADDRESS / ??? / ??? / ??? / ??? / AVAILABLE / NOT AVAILABLE
Jenny / 24 / ???????? / ??? / ??? / ??? / ??? / X /
Mark / 23 / ???????? / ??? / ??? / ??? / ??? / / X
Shawn / 28 / ???????? / ??? / ??? / ??? / ??? / / X
Lee / 33 / ???????? / ??? / ??? / ??? / ??? / X /
James / 38 / ???????? / ??? / ??? / ??? / ??? / X /
The new worksheet would see that there is an X in the Available box and input the rest of the row, but all the data would have no empty rows. (I do not want anything for the 'Not Available' section as there will be 3 or 4 different options so if there is a way of doing it, I will use a similar formula for each option.
NAME / AGE / ADDRESS / ??? / ??? / ??? / ??? /
Jenny / 24 / ???????? / ??? / ??? / ??? / ??? /
Lee / 33 / ???????? / ??? / ??? / ??? / ??? /
James / 38 / ???????? / ??? / ??? / ??? / ??? /
If that makes sense to anyone and you are able to help, please come back to me!
I am not great with the more techy formulas so if it is a very long one, I would appreciate if you could explain a little about how to input it.
Many Thanks
