E
enthrop
As the easiest way to explain what I'm looking to do, I'll just give a
example:
Name | Pay Salary
Albert | 50,000
Mike | 40,000
Phil | 55,000
Rachel | 45,000
I want to create a separate sheet that has only people who make 'x
amount of dollars.
So for example, sheet 2, people with pay between 40-50k:
Name | Pay Salary
Mike | 40,000
Rachel | 45,000
I know this must be a pretty basic thing, but I can't figure out how t
do it.
I want sheet 2 to have, by default, only the people w/ pay within
certain range. I DON'T want sheet2 to have all the names and then yo
have to select a filter or something to find those that have 40-50
(meaning if I was to give sheet2 to someone, I don't want that someon
to see everyone's pay, just those that are within a certain range)
example:
Name | Pay Salary
Albert | 50,000
Mike | 40,000
Phil | 55,000
Rachel | 45,000
I want to create a separate sheet that has only people who make 'x
amount of dollars.
So for example, sheet 2, people with pay between 40-50k:
Name | Pay Salary
Mike | 40,000
Rachel | 45,000
I know this must be a pretty basic thing, but I can't figure out how t
do it.
I want sheet 2 to have, by default, only the people w/ pay within
certain range. I DON'T want sheet2 to have all the names and then yo
have to select a filter or something to find those that have 40-50
(meaning if I was to give sheet2 to someone, I don't want that someon
to see everyone's pay, just those that are within a certain range)