l3m0npartii
New Member
- Joined
- Aug 28, 2015
- Messages
- 2
Hi,
I have two sheets in my workbook. One is linked and updated with another sheet in another file, and the second one is where I want to transport data to (from the first one).
So in the first sheet, I have a list of names along with some groups, levels, etc in which they belong to. I want to be able to write a formula where I can have a list of these names in the second sheet, however, only transporting those who are in a certain group or level. So far, what I use is the IF function such as:
*The formula is just to show you the idea, not the actual formula*
=IF(GroupnameB1=Team1,"",IF(LevelC1=5,"",NameA1))
So as you can see, I create a filter of the group, then I make the value if false to be another filter.
But here is the problem, if the person does not belong to neither Team1 nor Level 5, on the list I get in the second sheet there will be a blank.
I want to have a list of names of people who belong to team1 and level 5 but without these blanks in between.
help???
I have two sheets in my workbook. One is linked and updated with another sheet in another file, and the second one is where I want to transport data to (from the first one).
So in the first sheet, I have a list of names along with some groups, levels, etc in which they belong to. I want to be able to write a formula where I can have a list of these names in the second sheet, however, only transporting those who are in a certain group or level. So far, what I use is the IF function such as:
*The formula is just to show you the idea, not the actual formula*
=IF(GroupnameB1=Team1,"",IF(LevelC1=5,"",NameA1))
So as you can see, I create a filter of the group, then I make the value if false to be another filter.
But here is the problem, if the person does not belong to neither Team1 nor Level 5, on the list I get in the second sheet there will be a blank.
I want to have a list of names of people who belong to team1 and level 5 but without these blanks in between.
help???