Help With Formula

  • Thread starter Thread starter Report Lackey
  • Start date Start date
R

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.
 
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
 
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
 
Back
Top