Stuck! Unsure what I need (possibly vlookup)

Hello,

I have attached an example of what I'm working with (sensitive data removed). In the attachment, I'm using the formula in column F on sheet 1 to return the Top 10 values from sheet 2. Currently, the information is pulling all people regardless of their status (sheet 2 column B). I'd like to continue to use the formula in column F on sheet 1 but make it specific to also either pull by status (temp or perm).

The formula I'm using to return my Top 10 is:

=IF(COUNTIF(RAW!$AL$2:$AL$500,">0.05")>='Top 10'!A59,LARGE(RAW!$AL$2:$AL$500,'Top 10'!A59),"None")

I'd like to add to this formula a way to only return the top 10 Temp or Perm. I've tried adding a vlookup but I may be going about this wrong. Do I add an additional IF with specific conditions to the status? If so, I'm not sure how to make that work with my current formula. I'm really at a loss with this one. Please help!

Thank you!!!

Since you've copy/pasted these into a new spreadsheet, all the references mean almost nothing though?

I think you're going to need an array structure on LARGE, something like:

Please Login or Register  to view this content.

Where the status_range will refer the range B2:B500 where employee status is kept, and the "perm" or "temp" on the other side of the equals sign could be a reference to a control cell.

Array formulas are confirmed with CTRL+SHIFT+ENTER keys, not just the ENTER key alone.

You have a range offset error in that syntax, you're comparing values starting from X1 but pulling info starting from AC2. So you're pulling from the row above the correct row.

Please Login or Register  to view this content.

try that.