View Single Post
  #1   Report Post  
Steven Sinclair
 
Posts: n/a
Default Is this possible?

Microsoft Office Excel 2003

I have two rows of data. The first are numbers 1 through 100, the second are
how many occurrences of the number from the first row in another area of the
spreadsheet. This part works just fine using the countif function. It looks
like this:

1 2 3 4 5 6 7 8 9 10 ...
15 3 29 14 12 28 54 11 2 82 ...

Is there a way I can look at the second row, determine how many cells have a
value greater than 50 and then take the corresponding numbers from the first
row and copy those to different cells elsewhere in the spreadsheet? So in the
above example, it would copy the number 7 and the number 10 to different
cells elsewhere.

Thanx.