Need Help with formula

[Joefried]

please help me with the following info

"Cell A" is has the Modal Numbers (numbers could be doubled) i have over 5000 sales in "Cell A"
"Cell B" has the price (but could also be returns so that would be in a - forum)

now i would like "D1" to find me the first one that "Cell B" =<0.01 and the next line the same all the way down however i don't want a duplicate meaning "Cell D" should be unique

Best Regards
Joe

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=577572

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).