LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"