Sort by dept

  • Thread starter Thread starter acidity
  • Start date Start date
A

acidity

I have a spreadsheet like this:

First Last Dept Phone
Adam Apple HR 9489
Betty Boo IT 6503
CharleCee HR 8374

And I want it so that under the HR tab of the same spreadsheet I jus
see:
Adam Apple 9489
Charle Cee 8374

I need this to work under a heavily restricted enviroment withou
macros or vb

Any Ideas
Thanks in advanc
 
Hi
one way: enter the following in A2 (assumption: row 1 is a heading row)
on your HR sheet as array formula (entered with CTRL+SHIFT+ENTER):
=INDEX('mastersheet'!A$2:A$1000,SMALL(IF('mastersheet'!$C$2:$C$1000="HR
",ROW('mastersheet'!$C$2:$C$1000)),ROW()-1)-1)
and copy down / to the right
 
Back
Top