Help With Formula

[Report Lackey]

I have data in a worksheet
A B C
1 Verify 2% 99%
2 Audit 2% 98%
3 Account 5% 97%
4 Forward 4% 96%
5 Place 5% 95%

I have another cell (F1) in the sheet that i would like to
list the text in A1, but only if B1 is at least 5% if not
then I want it to list A2, but only if B2 is at least 5%
and so on down to A5. Please Help.

 

[Don Guillett]

What happens with row 3 and row 5?

 

[rob nobel]

One way is as follows
=IF(B1>=5%,A1,"") and copy down the rows.
Rob

 

[rob nobel]

Just noticed that you only wanted the result to appear in F1. I don't think
that's possible as if more than 1 item is 5% or more than you're going to
have a conflict.
Rob

 

[Tim C]

It's a bit clumsy, and I am sure there is a more elegant solution, but this
works:

=OFFSET(A1,SMALL(IF(B1:B6>=0.05,ROW(B1:B6)),1)-1,0)
array entered with Ctrl-Shift-Enter

It produces an error if nothing in B is over 5%

Tim C