Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |