.. list the item names and percentages for all items
that are more than 10% over budget.

Assume source data is in sheet named: x,
data from row 2 down
where col B = Item, col K = Percent

In another sheet,
In A2: =IF(x!K2="","",IF(x!K210%,ROW(),""))
Leave A1 blank

In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(x!B:B,SMALL(A:A ,ROWS($1:1))))

In C2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(x!K:K,SMALL(A:A ,ROWS($1:1))))
Format C2 as percentage. Select A2:C2, copy down to cover the max expected
extent of data in x, say down to C200. Minimize col A. Cols B & C will return
the exact results that you seek, all neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote:
I have a table of rows listing budget, actuals and variance for each line
item in my budget. The second column, titled "Item", contains the budget item
name and the last column, titled "Percent", is the percentage over or under
budget for that item. I want to create a second worksheet in the workbook
that lists the item names and percentages for all items that are more than
10% over budget.

Is there a function I can use to pull this list of item names and
percentages? Pls give me an idea how to write this function.

Thank you for your help, John