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