Ron, I want to place the answer on another spreadsheet within the same
workbook. Where would I insert the name of the worksheet within the formula?

"Loadmaster" wrote:

Ron, I found what my error was in the formula after playing around with it
for a long while. I had a ) in place of a } and I was putting the word rng
vice inputting the range. Thank-you very much for your help.

"Ron Rosenfeld" wrote:

On Wed, 16 Jul 2008 16:54:11 -0700, Loadmaster
wrote:

I do want the last 3 and 12 entries in column K. My first post this morning
showed you the layout of the spreadsheet. What I was looking for did not
work. It seems like the formula you gave me was looking for a larger number
each month, this is not the case. Column K just has the monthly flying
hours, some months are smaller/larger than others. The amount of empty cells
between the monthly figure varies with however many flights I flew that month

How did you conclude that the formula I gave you was "looking for a larger
number each month"?

The formula was designed to "look for" the three numeric entries (or 12) in the
highest numbered rows, and it works as designed here.

So please post some real examples of your data, a true copy of what you did
with my formula, and the results you obtained.
--ron