View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Selecting last five numbers in a selection

I have a series of data in the same row, (F5:AC5) containing anywhere from 1
to 24 numbers. In cells AD5:AH5, I want to determine the LAST five numbers
entered in the row of data (not smallest or largest, but simply the last
numbers that were entered in). There could be duplicate numbers, and blanks
in between cells of numbers. How would I go about this?

Thanks.