I can't think of any formula but you can do this with Data-Filter-Advanced
Filter

Assuming the lable of column C is amount
then enter anywhere in a blank area
Amount
500000

Then chose these two cells as Criteria Range in the Advanced Filter.

"scott" wrote:

I want to pull information from a list of data, but only the data that is
greater than 500,000. In c1:c30 i have data and c13, c16, c28, c29 are less
than 500,000. I i want to create a new list adjacent to the existing one
using only the values greater than 500,000 what function would i use? i was
thinking:

if(c1<500,000,"",c1) but this would leave that particular cell blank.

thanks for the help